Home Forums SQL Server 2008 T-SQL (SS2K8) MERGE Statement DELETE from TARGET when not in SOURCE 'hanging' RE: MERGE Statement DELETE from TARGET when not in SOURCE 'hanging'

  • When you say "hanging" what do you mean? I take it as there is something blocking which in turn implies that the update would not complete.

    Like I said, check any blocking SPIDs and also check the query plan of your statement.