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]

No comments: