Hello,
I've created a #temp table in SQL containing duplicate records.
I would like to remove from my primary table all of the records contained in this temp table. I see samples to do this but they seem to all invovle selects, and I already have my select in the temp table.
Here's what it would look like in pseudocode:
DELETE FROM MyMainTable(unique and duplicate records) WHERE the record exists in #temp