Thanks for your response..

I need little more specific..

Business logic is I need to export all values from a table without any duplication. I considered Test. Test.. are the duplicates.

The value...

Great Video.

Hi,

When you create a foreign key, it should reference either primary key or Unique key.

In table GV_Voucher, please make sure TransactionID as Primary Key or Unique key.

Hi,

CREATE TABLE #Temp

(

AutoId int,

EmpId int,

TimeIn datetime,

TimeOut datetime

)

INSERT #Temp (AutoId, EmpId, TimeIn, TimeOut) VALUES (1, 1009, '10-13-2012...

Hi Dude,

Instead of using CURSOR you can try WHILE loop like below example.

If possible dont use CURSORs in the procedure.

DECLARE @tblMain AS TABLE (dateC DATETIME, valC FLOAT)

DECLARE @tblMain2...

Hi,

Try this code..

CREATE TABLE #IREMS (ItemID INT, City VARCHAR(20))

INSERT INTO #IREMS (ItemID , City )

SELECT 11, 'a' UNION ALL

SELECT 22, 'b' UNION ALL

SELECT 33, 'a' UNION...

Hi Kiara,

Please check the below modified code.It shows your expected result.

select p.projectid,

apCount = COALESCE(countap,0)

, arCount = COALESCE(countar,0)

from #projectList p

left...

You may get better insight through the link

I have a blog article to maybe assist you with your question:

http://www.sql-programmers.com/Blog/tabid/153/EntryId/16/Stored-Procedures.aspx

SQL Server Programmers and Consultants

http://www.sql-programmers.com/

I have a blog article to maybe assist you with your question:

http://www.sql-programmers.com/Blog/tabid/153/EntryId/6/Using-PIVOT-and-UNPIVOT.aspx

SQL Server Programmers and Consultants

http://www.sql-programmers.com/

Iif((SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) <> 0,

(SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

SUM(Fields!Count_Equipment_Delivered.Value)), 0)

((Iif(SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) = 0,

(SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

SUM(Fields!Count_Equipment_Delivered.Value)), 0))

In the above code I assume that , the following is first part and the remaining is second...

Try this,

CREATE TABLE tblXML (ID INT PRIMARY KEY, xmlVal XML not null)

insert into tblXML values(2,'<a><b>1234</b></a><a><b>222</b></a><a><b>333</b></a>')

select * from tblXML

SELECT x.query('b').value('.','varchar(100)') as Product

FROM tblXML CROSS APPLY xmlVal.nodes('/a') AS Tref(x)

Result:

Product

1234

222

333

Using PIVOT .......

See this link .this will give you example Query......

Link:

http://www.sql-programmers.com/Blog/tabid/153/EntryId/6/Using-PIVOT-and-UNPIVOT.aspx

SQL Server Programmers and Consultants

http://www.sql-programmers.com/

Hi Sethuraj,

Check your reply, the variables still having the old values

DECLARE @Var1 varchar(100),@Var2 varchar(100)

SET @var1='Sethuraj'

SET @var2='Sahithya'

select @var1,@var2

SELECT SUBSTRING(@var1+@var2,CHARINDEX(@var2,@var1+@var2),LEN(@var1+@var2))

SELECT SUBSTRING(@var2+@var1,CHARINDEX(@var1,@var2+@var1),LEN(@var2+@var1))

select @var1,@var2

I have a blog article to maybe assist you with your question:

http://www.sql-programmers.com/Blog/tabid/153/EntryId/6/Using-PIVOT-and-UNPIVOT.aspx

SQL Server Programmers and Consultants

http://www.sql-programmers.com/

As per my assumption there is no possibility of swapping the variable values with out using temp variables in SQL 2000. If it is 2 columns then this is...