In this episode, we're going to look at how to pivot your data in SQL Server T-SQL queries. Pivoting is a very useful way of transforming data, and one of the most effective ways to show summary data. First I'll show you how to do a pivot query with static columns, and then I'll show you a more advanced method that will allow you to have a dynamic display of an unknown number of columns. This tutorial will also introduce you to the STRING_AGG function, which simplifies the creation of a delimited list in SQL Server 2017+ and Azure SQL environments.
Avoid hidden costs and complexity. Get Virtual machines, S3 storage, and more, on your own cloud network.
https://beaverdamtechnologies.ca
Want my team to do a project for you? Let's get to it!
https://buy.billzone.com/smdeprojects.html
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
https://www.patreon.com/mackenziedataengineering
Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at http://www.mackenziemackenzie.com/
Follow me on social media:
https://www.facebook.com/mackenziedataanalytics
https://twitter.com/seamacke
https://www.instagram.com/seamacke/
https://www.reddit.com/user/seamacke
https://www.linkedin.com/in/psmackenzie/
Thank you to my viewers!
Mention Promo Code SMDE25TWELVE for 25% off a twelve-month virtual machine subscription at:
https://beaverdamtechnologies.ca
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenziedataengineering
#sqlserver #pivot #tsql
https://youtu.be/KHNl4pXqYAI
