Correct. The only snag I'm running into is -

where

FacilityID <> @FacID;

There is a possiblity (even if small) that there could be multiple FacilityID's in the...

Basically, we need to update a row only if a row has changed or been added. No update to untouched rows.

The stored procedure uses a SELECT statement to query the Facility table on the backup server. It then stores the query'd FacilityID into a variable. It will then...

Because the replicated ID could vary, we wouldn't be able to hardcode a value to look for and replace. The stored procedure would need to have a little more...

Why does it feel like we might be looking at the same db? LOL!

That's a good idea. I think the plan is to correct the db in the future, but for now to run a script to see if the table has...