My Work
My Blogs
Hotlinks
Tag Archives: pivot
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
