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,535 reads
Paul Milligan
2016-11-21
3,670 reads
Blogs
Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up
By SQLBalls
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container...
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
Forums
Usage of #TempTables and an Index in Stored Procedure
We have a stored procedure, working for yonks, which has a CREATE session temp...
Referencing a table type In Dynamic SQL
I want to use a table variable in a merge statement using Dynamic SQL...
modify dtsx connection
Hello Team, kindly advise how to change dtsx connection? below is source details: Data...
Ask SSC