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
4,024 reads
Paul Milligan
2016-11-21
3,108 reads
Blogs
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Get SQL Server 2022 Now: It’s Called Azure
If you’re like me, your palms went into a cold sweat to get your...
Daily Coping 29 Nov 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Get Summary Data for Last 52 weeks by Week
I have a table which stores shipment data by date. We have a need...
create index columnstore
hello , Who has any idea please how to rebuild a clustered index to...
Ask SSC