create procedure loopcure
as
BEGIN
declare @a int, @b  varchar(020), @l int, @c  varchar(020),
@D  varchar(020)
SET @D  = ''
declare  loopcur cursor for select id from names 
open loopcur
fetch next from  loopcur into @b
while @@fetch_status = 0
begin
select @C = LTRIM(RTRIM(@B)) + ',' 
select @D = LTRIM(RTRIM(@D)) + LTRIM(RTRIM(@C)) 
fetch next from  loopcur into @b
end
close loopcur
deallocate loopcur
select @d = left(@d,  len(@d)-1 )
select @d as final
END

Hi Friend,

If u use SQLSERVER 2005 u can try like this............

CREATE TABLE EMP ( ENAME VARCHAR(25))

INSERT INTO EMP VALUES('Ganesh')
INSERT INTO EMP VALUES('Narendra')
INSERT INTO EMP VALUES('Rinku')
INSERT INTO EMP VALUES('Selvam')
INSERT INTO EMP VALUES('Kirti')

SELECT REPLACE(REPLACE( 
 ( SELECT ENAME AS EmpName FROM EMP FOR XML PATH ('') ) ,'<EmpName>',''),'</EmpName>',',')

DECLARE @chrString as varchar(200)

select @chrString=@chrString + ',' + Name from Names

? @chrString