By Adam Bean, on November 24th, 2009
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 [...]
By Jeff Mlakar, on November 6th, 2009
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 [...]
Comments