Home Forums SQL Server 2008 T-SQL (SS2K8) merge a result set with a table but update according to existing values in target RE: merge a result set with a table but update according to existing values in target

  • The error in the MERGE statement is encountered when one row in the target table will be addressed by more than one row in the source data set.

    This imples either that the matching criterium is incorrect, or there is more than one update per record in the source dataset.

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”