Just for fun I ran across a bit on multi columns with Pivot. Here's a solution I came up with. Feel free to improve upon the example. The purpose was to fiddle around with Common Table Expressions, etc. Note: The datasource for this was Northwind, thus the 1996,7 and 8 dates... :)
With...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.