Sorry about the duplicate post.

Was just curious to know the best solution.

Hi,

I have added the sample data.

Regards

Richu

Hi Guys,

I finally got it through a simple CTE expression and inserting the data into a temp variable and finally deleting the ids present in the temp variable.

Hi Dave,

Yeah i have a set if id's that is in the main Table1

eg)If i delete an ID 0 in the main Table 1 then the children 1 in Table2,the...