...
I really appreciate your help. My reasoning was that do I have to repeat all the "Select Union" statements for all the rows that i have?
I could be missing something! Please advice
Ough! Just that? That was used to create and populate a sample table and data for demonstration. I expect you have your table in place already with data populated...
😉
If you want to populate another table, just add INSERT INTO [RequiredTable] before SELECT statement which does the work.