DELETE from Source_Data Where ID in
SELECT ID from My_Temp_Table where FLAG = 'Y'
Essentially, I want to update a DB table with either an update or with the deletion of rows. I can't delete all of the data. My work around will be to create/insert into a table the keys that i want to delete and try to use a input/output tool with SQL that performs the delete. Any other suggestions are welcome, but a tool is best.