DECLARE @LatestRegion INT SELECT @LatestRegion=[LatestRegion] FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @KillerID IF (@LatestRegion IN (Put id region what you need)) begin update whatever