My objective is to use the same technique to select results from one CTE and insert them into another table using a different CTE. How do you do it?
invalid object name xy.
My query is:
Select a, b, c
select d, e, f
where (uses conditions from ds)
from ds (the result set of ds, am exporting this to csv)
Insert into AuditTest
Select * from xy
Can someone please help me with this?