Ever wish your horizontal data were vertical for easier data storage, as well as vice-versa for reporting purposes? Are you writing elaborate routines to transform between them for one-time usage? Are your queries repeating “OUTER JOIN” or “UNION” so often that you wind up back in Kansas when you read them aloud? Let's visit SQL Server’s lesser-known PIVOT and UNPIVOT operators. After this session, you will no longer need to rotate your monitor!

Intermediate, 300-level class, 60-minute slot