Transforming Data using the T-SQL PIVOT / UNPIVOT operators
Duration: 90 minutes
Track: Application & Database Development
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? Join Jeff Foushee as he explains SQL Server's lesser-known PIVOT and UNPIVOT operators using SQL 2016. After this session, you will no longer need to rotate your monitor!