Posted by: Jhilke_Bro July 29, 2019
Login in to Rate this Post:
0
?
Copy the result set from the following query and patch with INSERT INTO dbo.DestinationTable(ColumnA,ColumnB)
SELECT 'SELECT '+ ''+ColumnA+''+','+''+ColumnB+''+' UNION ALL'
FROM dbo.TableName
SELECT 'SELECT '+ ''+ColumnA+''+','+''+ColumnB+''+' UNION ALL'
FROM dbo.TableName