That's the whole point. There might not be a record at all in the source server. I think in my case, the answer is IF EXIST...THEN....ELSE, rather than Merge

Merge would...

Hi Mitesh

There is still an issue. The script is not correct as it will perform and insert every time it is executed, along with an update if found.

Any other ideas?

Vik

Thanks Mitesh

In my case, the LGI_GROUPID is a primary key with identity increment and therefore the code you supplied may not work. I modified my code as follows and am...

Please bare in mind that LGI_GROUPID is a primary key in the target table and a foreign key in the source table.

Thanks heaps guys....much appreciated

yes...you are right

and the date column is a typo...it is actually in proper date format.

Do you have a solution?