SQL Query | Convert data from columns into Rows | Unpivot

what if pivot with null ?

Exactly what I needed. Your lessons are succinct and to the point

great video! appreciate this!

This is an important query which was asked to me in the NatWest interview

Thank you for your valuable contribution. Best regards from Venezuela.

How to convert all column data types into nvarchar datatype in table

I can't thank you enough for this, you are awesome 🤩

Amazing🇵🇹 cheers from Portugal

How to do unpivot operation on dynamic columns

Can't be dynamic like if data comes for 2021,2022 etc ?. it will add new column or row?

The UNPIVT_SALES was already created earlier or just an alias?

Thank you. Very helpful. What do you do if you have many columns ( a few hundred) that you need to unpivot? It's not practical to type all of them into a select statement.

Thank You

Thanks 🙏