Hi tried a few different ways to do it. Declaring a table, that output into a @table I declared. Once that was done I did an

insert into Table1 (Column1, Columns2, etc) select (Column1, Columns2, etc) from @table where [Action] = 'DELETE'

I could not get all the info I wanted.