Hi Everyone ,

Thanks for your quick response .

Here is the problem .

1) Using merge script while inserting data into the table (Sql server 2012).

2) After inserting a particular set of data which is based on Dateid column .

i am inserting another set of data i.e based on another Dateid .

3) Count of earlier set of data is getting reduced .