When rolling up data using Group By one of the things that has been missing in TSQL is the ability to concatenate. You can SUM, MAX, MIN etc...but no concatenation.  There are various methods that…

Read more...