Showing posts with label combine rows with single column. Show all posts
Showing posts with label combine rows with single column. Show all posts

Friday, April 2, 2010

combine rows with single column in Sql Server 2005

combine rows with single column--Query to combine multiple rows into one
DECLARE @str VARCHAR(100)
SELECT @str = COALESCE(@str + ',', '') + [ct]
FROM #cat1
Print @str

Here [ct] is column name that we have rows of data. Then finally entire rows of data is avilable in @str.

Example:
ct
--------
suresh
hemanth
kareem
malli

after processing with COALESCE then the output loks like.....
----------------------------------
suresh,hemanth,kareem,malli