hi scott, thanks for your reply, i am trying to perform SCD type 2 using merge and get insert, update counts. the solution which you provided supports only inserts in...

sorry for presenting it poorly, according to the technical requirement document we cannot use separate inserts and updates and need to use Merge for better performance.

hi phil, thanks for the reply, we cannot separate inserts and updates and need to continue use of merge in this requirement.