Tip: Concatenate rows with XML, or COALESCE

(Jen McCown) I still reference my Forgotten T-SQL Cheat Sheet, especially for the XML trick that turns a set of rows into a list. The T-SQL Cheat Sheet example uses a parent-child table combination, but what if we want to get the same effect from a single table?

Read More - Register for Free Membership