I would like to share cool feature of SQL Server with you guys like:

Please use the following query when concatenate two or more rows with comma (or any you want) in a single string.


SELECT STUFF((SELECT ',' + RTRIM(RegionDescription) FROM Region FOR XML PATH('')),1,1,'') AS 'Regions'


This would be also useful when you have to check between condition in SQL Query.

Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/RVFdOjcnkas/14187