This request also sounds odd to me. I'm also a newbie and I don't even know what to ask online until I encounter something new I can't figure out. Odd that I come to visit the site today and see this question as I just downloaded the
Adventure Works DB to look at Pivots.
If by "pivots", you mean the PIVOT operator, have a look at the following two articles...
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]
Jeff, that is exactly what I meant. 🙂 I have been looking at some other articles about PIVOT.
-Mark
MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.