|
Dom,
Reading through the query in the original post, it already grabs the two duplicate machines and determines which one has been updated more recently. That being the case, I would think you could just replace the line that executes the merge stored procedure with one that replaces the delete stored procedure (which I can't remember the name of right now):
So instead of:
exec spResourceMerge @FromGuid,@ToGuid
You'd do:
CAUTION - Just thinking out loud here, have nowhere to test it at the moment - CAUTION
exec spResourceDelete @FromGuid (or whatever the delete stored proc is called)
|
