My Work
My Blogs
Hotlinks
Tag Archives: coalesce
What if you want to PIVOT against a text column?
If you’ve ever worked with or researched SQL Server’s PIVOT function, you probably noticed most of the samples pivot against an id column. Typically an int column like EmployeeID, or StoreID. That’s fine and dandy, but what happens when you … Continue reading
Posted in database, microsoft, SQL, tips and tricks, tsql
Tagged coalesce, dynamic sql, exec, pivot, quotename, SQLSERVER, table variable, tsql
2 Comments
Create comma seperated list out of a sql query ( tsql )
Surfing the net for a sql answer, I came across something really cool. Below is an example of how to create a comma separated list of values in a single query. The results should look something like this
