Crosstab queries using PIVOT in SQL Server
In this tip we look at how to construct a SQL Server PIVOT query with an example and explanation.
2019-04-04
Crosstab
All About the Crosstab Query
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
2010-01-13
5,114 reads
Simple Crosstab Procedure with Power
Create crosstab queries as easily as MS Access with a lot more power.
2014-09-09 (first published: 2009-04-02)
4,427 reads
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.
2010-04-30 (first published: 2008-12-03)
49,449 reads
Blogs
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Daily Coping 24 Mar 2023–The Final Tip
By Steve Jones
Today’s coping tip is to discover the joy in the simple things in life....
Experimenting with RedisGraph on Docker and Windows
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
Forums
Slow performance when processing a JSON file in Azure
We have a stored procedure that can load up a JSON file and process...
dbatools - Connect-DbaInstance
I have my SQL servers name, UserID (UID) and Password (PWD) in a table...
Extracting the string before and after the given character
Hi All, I want to extract the string before and after the given characters....
Ask SSC