Thanks Steve for understanding my problem and suggestion/help.

Further, I would like to know how can I know if there is any update in Master or detail table? Again I need to...

Again YES, I already mentioned that we also input some schedules locally aswell and the autoIncrement is not sync with our HeadOffice Tables.

Shamshad Ali.

well, ur not getting my question. The problem is that my Local_* Tables has its own autoIncrement column and based on that (unknown value) i have to insert records in child...

Yes, that is right. Actually, I want to know how i can do it using triggers or write if Exists (with all possible cases) and use cursor to insert 1...

As I told already,I have two ways, One is to use Triggers and the second is use of CURSOR.

Draw back of Trigger is that, we have to foward our own Information...

We have already copy of Head Office schedule Tables as subscriber Tables but the problem is that, both locations has their own Identity auto Increment and the detail table is based on that auto increment...

Thanks for the help. I have implemented and it works perfect. By keeping same scenario furthermore, I require to input DOB @FromDate and @ToDate and @FirstName and @LastName as Parameter passed to this query, we have only...

Thanks all for your great help, I have implemented and test it on my real data where I have been assigned to improve performance and the result should be same...

Here is my query result if I use left outer join:

select MyList.[Name], convert(varchar, DOB, 107) as DOB,

Count(case when Library.Auto_ID>=1 then 1 else NULL end) [Total in Library],

Sorry, it works logically, but it produces wrong resultset. I have tested it before my submission here. Better if someone faced this situation and solved it in a single...