Table Child ID PARENT_FK

Table Parent ID

I want to delete all of the parent rows who do NOT have children. How would I do that?

Richard Cherry

Its been a long day so test the sql in your favorite query tool to verify it =P

But your SQL is something like this, you should be able to use this to generate a predicate..

SELECT * FROM dbo.Parent P (nolock) LEFT JOIN dbo.Child C (nolock) on C.ParentKey = P.ParentKey WHERE C.ParentKey is null -- can actually be any field in the child since all fields return null

Just add the relation with a left hint and the compare predicate.

John

Execute a ParentCollection.DeleteMulti(filter, relation) call, where filter is a filter on Parent.ID is NULL and the relation collection contains the relation Parent-Child with a joinhint LEFT.

(edit), heh, John was slightly faster