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,397 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)
47,641 reads
Blogs
Daily Coping 21 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Bulk insert.
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...
Lambda Architecture in data systems and possible meaning of this name
By Rayis Imayev
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...
Forums
Difference between SaaS and web application?
I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for...
Reducing Temp Table Scans when joining two temp tables using OR conditions
Hi all. I have also posted this on DBA Stack Exchange, but I'm posting...
question about username dbo
I have been asked to revoke access from a few developers in SQL Server...
Ask SSC