Ever wondered that how to get a comma (pipe or whatever) seperated result for a column in a table.
The following statement show a simple example you can take as a starting point.
Select (Stuff((Select ', ' + FName From Accounts FOR XML PATH('')),1,2,''))
Submit an article or tip
