Thursday, December 13, 2007

HOW TO CONVERT COLUMN VALUE IN COMMA SEPARATED STRING


USE Northwind
GO

DECLARE @strCSV varchar(1000)
SET @strCSV= ''
SELECT @strCSV = @strCSV +','+ FirstName FROM
Employees
SET @strCSV = SUBSTRING(@strCSV,2,LEN(@strCSV))
print @strCSV

1 comment:

Rahul Kashyap said...

good very good nice mane bhi frind aaj he apne site bnai hai jeska nam hai kashyap18k.blogspot.com ok by you take care