Thank you Lutz. It is working according to the expectations and it seems the problem in the original scenario will be resolved 😀

Thanks again and God Bless you and...

Thank you Lutz for the reply. As I also want to run it on SQL Server 2005 then what changes are required in this code.

in the example quoted below by a fellow the insertion should not be done as ActivityIds 2, 4, 5, 6 already exists against the ActivityControllerID 4

DECLARE @tbl TABLE

(

...

Thank you Bro for your interest in this issue and I really appreciate your efforts in this regard. But the problem still exists. If i modify example quoted by you...

AcitivityControllerID can be any number suppose the following data needs to be inseted in ActivityAllocaiton table

ActivityID

3

4

5

6

ActivityControllerID------------ActivityID

11------------------------------3

11------------------------------4

11------------------------------5

11------------------------------6

Now see ActivityID 3, 4, 5, 6 already exists in the table ActivityAllocation but still...

Thanks 4 ur comments now I’m assured that it’ll not work in this way.

Regards Kamran :hehe: