A Possible Alternative to SQL UNPIVOT
Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.
2017-01-16
3,697 reads
Paul Milligan
2016-11-21
2,698 reads
Blogs
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
Daily Coping 14 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
WIT Mental Health and Wellness Videos Posted
By Steve Jones
I was honored to speak at the WIT Mental Health and Wellness day last...
Forums
unable to deploy package unable integration service catalog
Hi I get teh following error while deploying package .NET Framework error occurred during...
Limit database restores to specific drive locations
As there isn't an option to use a DDL trigger on a RESTORE query,...
VLOOKUP Equivalent in SQL
Hi there I have two tables, one with an ID and Amount (Table 1)...
Ask SSC