USE SRO_VT_SHARD
declare @
[Only registered and activated users can see links. Click Here To Register...]mobid int = --OLD MOB ID
declare @
[Only registered and activated users can see links. Click Here To Register...]bid int = -- NEW MOB ID
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, @
[Only registered and activated users can see links. Click Here To Register...]mobid, @
[Only registered and activated users can see links. Click Here To Register...]bid) from Tab_RefTactics t
inner join Tab_RefNest n on n.dwTacticsID = t.dwTacticsID
inner join _RefRegion r on n.nRegionDBID = r.wRegionID
WHERE dwObjID LIKE @
[Only registered and activated users can see links. Click Here To Register...]mobid and r.ContinentName in('CA','AM')