ETL SQL
Simply stated question:
I'm writing an ETL query between two databases in Azure SQL.
Source:
One table with two columns: The first column contains the text of one a predetermined set of questions, and the second column contains the text of the response.
Target: Pivot the above into tables with columns named for all possible questions, to be populated with the response data.
I've been trying different types of pivots and the only way I've been able to get this work is by typing out every single column. I need to populate in the target. I'm looking for a more elegant idea to pursue.
Thanks, and always remember to carry a towel