Top "Unpivot" questions

UNPIVOT describes a Query Language feature of some Relational Databases.

How can I get around differences in column types when using unpivot?

I am having problems using unpivot on columns, that are not the exact same datatype, and I can't figure out …

sql sql-server tsql pivot unpivot
How to unpivot in BigQuery?

Not sure what functions to call, but transpose is the closest thing I can think of. I have a table …

sql google-bigquery transpose unpivot