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
unpivot
Unpivot SQL Select Data
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,389 reads
2014-10-16
1,534 reads
2014-04-17 (first published: 2014-03-25)
1,277 reads
2014-04-22 (first published: 2014-02-20)
2,172 reads
Blogs
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
Forums
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Duplicate Documents
Hi Experts, I am trying to find duplicate documents stored in our Filestream database....
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers