Hi Guys !

This is a sample of a Cursor ! I am giving a sample of problem i got , In The End OF Cursor In "Print @Des" I want Results As Follow

A;B;C;
While I am Just Getting
C;
Can you please Point Me Out , what is missing !


-- Here Is Table With Data
Create Table #Temp (Des Varchar(10))
Insert Into #Temp Values ('A') GO
Insert Into #Temp Values ('B') GO
Insert Into #Temp Values ('C') GO

-- Here Goes Cursor !

DECLARE CUR_Temp CURSOR FOR
SELECT Des FROM #Temp

OPEN CUR_Temp
DECLARE @Des VarChar(50)

FETCH NEXT FROM CUR_Temp INTO @Des
WHILE @@FETCH_STATUS = 0
BEGIN
Set @Des = @Des + ';'
FETCH NEXT FROM CUR_Temp INTO @Des
END
Print @Des
CLOSE CUR_Temp
DEALLOCATE CUR_Temp



Thanks For you People Concerns !
MS Sql Server LazyDBA home page