Showing posts with label Multiple Record value in One Filed. Show all posts
Showing posts with label Multiple Record value in One Filed. Show all posts

Thursday, November 20, 2008

Get Comma Seperator Value in one Filed

select STUFF ( (SELECT ',' + [Column_name]
FROM [TableName] WHERE [Criteria]
FOR XML PATH('')), 1, 1, '') AS [DIsplay Name]