Microsoft SQL Server Forum

good day. sample database: table1 col1 col2 col3 A item1 100 A item2 200

Hi every one. i want to write a query to get the records of last 12 months in sql like in LINK in its ARCHIVES section at side bar. any kind of help will be greatly appreciated. Regards Mudassir

Hi, I have an application that used to need SQL Server but no longer does. I have removed all database modules and references to SQL wherever I can find it. I have also removed the Prerequisite checkbox for SQL Server 2008. However the application still has the following notice on installing. Component SQL Server 2008 Express has failed...

How to convert this sql statement to storeproc? select "Dly_DC_LostSlsSnpsht_v"."PlntCd" "Plnt_Id_Cd" , "Dly_DC_LostSlsSnpsht_v"."DivCd" "Div_Cd" , "GlblCatSum"."GlblCatSumCd" "Gbl_Cat_Sum_Cd" , (coalesce("GlblCatSum"."GlblCatSumDesc", 'Unknow')) "Gbl_Cat_Sum_Desc" , "Dly_DC_LostSlsSnpsht_v"."ProdtCd" "Prod_Cd" ,...

Hi,Am Dennis and I interact with Sql server on my daily bases.Am currently loading my data on my sql server to be used in OPENCBS and it is working well.The problem is when I try to add a new client in OPencbs am receiving the below error Violation of PRIMARY KEY constraint 'PK_Persons'. Cannot insert duplicate key in object 'dbo.Persons'. The...

Hi All, I am trying to append two tables,those present in my database. The theme i want to output as,display all the columns from both the tables in the result. Means that if the first table contains 3 columns and the second table contains 4 columns. so Total 7 columns i want to display in the result.(remember one thing that there is no...

Hi All, I want to get the previous row data in the same row with the new column name by comparing the above row data. Means that i have a table in sql server with 2 columns.First column name is "ItemCode" and the second column name is "Level". The second column has numeric data.so i want to compare the second row second column data with...

I have three bit fields in a table that I have set to NOT NULL so that I can link to the table from MS Access. On each of these three fields, I have setup default constraints to set the value to False (0). This has been working for over a year now. All of a sudden, they have stopped working and every time I try to add a record to this table...

Dat file generated by X application.This file in paradox database folder of this application. The main output data from the machine saved in this dat file. But, I could not read the content. Help me on how to read this dat file. A part of dat file content: £<,?síÂ;ù÷™=�Âõ<wA?5)¼;M¡³=ìQ8=M@W?êMó;¡JÍ=�Âu=i´v?mUÐ;öóæ=¸…= ±ƒƒ?áŠè;¥N...

I have 2 databases. These are host on different different servers. I want to join the tables of those databases. here..(1) UserId is same in both database table (2) Table name are TB1 and TB2 (3) Database are DB1 and DB2 i want to bind the data in a gridview from both database's tables. Note 1 :-Is this possible to...

I have problem in my code when try to implement message: Invalid object name 'empl'. empl-> is my table code: Con.Open(); MessageBox.Show("connected"); SqlCommand cmd = new SqlCommand("INSERT INTO empl (name,password) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "') ", Con);

Hi, A have a problem to make ODBC connection from ORACLE database to MS SQL Server. I’ve already achieved to connect with sqlcmd. So the servers see each others and can communicate. The ODBC driver fails at the authentication, because it can’t read the user and password data from the odbc.ini file. I read that this happens because the odbc...

How to insert db paradox file to sql automatically in a readable format. The db paradox file can be read by using software such as gnumeric spreadsheet and paradox d-base reader. From gnumeric spreadsheet , I can manually export db file to other format to be inserted to sql server. I would like to know if there are automatic way to convert db to...

i have on procedure named as VouMasterEntry that is :- Create PROCEDURE . -- Add the parameters for the stored procedure here @VouNum int, @CustID nvarchar(30), @VouCat char(10), @VouType Char(15), @Seldate smalldatetime AS

Dear all. Let me explain a simple scenario. suppose i have two tables tbl_Leads and tbl_Leads_Correspondence. and i have following data in both table tbl_Leads LeadID lName lDate 1 first 2014-11-24 22:22:52.523 2 second 2014-11-25 22:22:52.523 3 third 2014-11-26...

I have a table Rent_Payment with subclasses checks and like_value (PK is payment_ID). Each of the subclasses have a description (ex: like_value has 'Fixed a car'). Tenant pays the Rent Payment (linked by FK tenant_ID). I want to display: Tenant, and description from the subclass of how they paid. I unioned all the subclasses but I don't...

Hello! I have Contract and Rent_Payment. I want to make it mandatory one to mandatory many so that a Contract must have one or more Rent_Payments. I understand that after I create both tables, I then use How do I deal with this? I figured it out! Cant figure out how to delete though...

Dear all i have 2 tables table 1 email name email1@gmail.com name 1 email3e3@gmail.com name 2 table 2 id email 1 email1@gmail.com

Hi, I wonder if anyone has any pointers to this. I have a page querying cities from my database. fields to query in database country australia uk uk

Hi, SQL back end, Access front end. I have a table for entities and folks now want to be able to capture notes on an entity. Lengthy notes of text/numbers. I've seen on the web a SQL data type of nvarchar (max) but have never used it. Would that work? Any other options? I know Access has a memo data type but believe that is not an option...

This question was asked by Fredrik M?ller but can't see any replies. I have a problem with Transactional Replication over a WAN. Server A is a distributor and server B is a publisher. Sometimes the network goes down and replication fails. When the network comes up again the log reader at server A continues to fails. To get the replication going...

How to create a password column and password must be encrypted?

I can SELECT CONVERT(VARCHAR(8), DXACCNUM) but I cannot SELECT CONVERT(VARCHAR(8),DISTINCT(DXACCNUM)) I am merely trying to make that int column 8 char wide. Any ideas from anyone? Thanks!

Hi all, I have an SQL query that bring back data for customer contacts (name, telephone number, time of call, agent ID e.t.c) which is run manually every day. The business now requires me to extract this data every 15 mintues, and i don't want to have to do it manually as i wont have time to anything else with my day! I would like to find...

I am struggling with some results in which I had to take values from a single column and derive separate columns. Now I have three columns and three rows that I wish to combine into a single row where the column RowNum is share. Any tips? The query and results are below. SELECT DISTINCT RowNum, chem_name, amt, measure FROM (SELECT...