Forum Posts

Admin database 1.1 RC3 is available

http://www.sqlslayer.com/wp/admin-database/

Sorry for the lack of update lately … There are many new updates to the admin database. I will do my best to try and work on a change history as well as provide a better change history log per release. One thing to note, we are adding new 2008 specific objects, which require an [...]

Aggregate to CSV

Sometimes we need to rollup string values into lists of comma separated values. Using “FOR XML PATH” per column that you want to rollup can provide a way to do this.

This example was created based on work in this thread:
http://www.sqlservercentral.com/Forums/Topic802508-1672-1.aspx

Let’s say you have a data set like so:

id
fruit
city

101
Apple
Cleveland

101
Apple
Pittsburgh

101
Banana
Pittsburgh

102
Grape
Cleveland

102
Melon
Cleveland

103
Melon
Pittsburgh

103
Melon
Cleveland

and for each distinct “id”, you want [...]