Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY
Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
2023-11-24
Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
2023-11-24
Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.
2016-12-08 (first published: 2015-01-26)
2,391 reads
2014-10-16
1,536 reads
2014-04-17 (first published: 2014-03-25)
1,277 reads
2014-04-22 (first published: 2014-02-20)
2,173 reads
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Comments posted to this topic are about the item Life Moves Pretty Fast
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Comments posted to this topic are about the item 50 Years of Microsoft
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers