How to delete all records in a table based on selected record from another table

Question

How to delete all records in a table based on selected record from another table

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399330 More actions · Answer 1

If I understand what you're asking for, I think the OUTPUT clause is what you're looking for. That will allow you to know exactly which records were deleted from the first table, and use that to delete in the second table.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

DesNorton SSC-Insane Points: 24619 More actions · Answer 2

I gave you an example of how to do exactly this in your previous post

https://www.sqlservercentral.com/forums/topic/how-to-delete-records-selected-from-another-table-in-stored-procedure#post-3976526

You just need to change the table names

How to post data/code on a forum to get the best help.

John_Kennedy Old Hand Points: 330 More actions · Answer 3

Hi,

It was my mistake here. I need to delete all records associated to Setid in ExamLog table only, not from ExamSet table. ExamSet is only for fetching old Setid records based on CreatedDate.

This reply was modified 3 years, 9 months ago by John_Kennedy.
This reply was modified 3 years, 9 months ago by John_Kennedy.