
--SetBHKR01: K
UPDATE NACRS_Project
SET DataField3 = 8923
WHERE ProjectNumber = 131
  AND DataField1 = 8880
  AND DataField3 = 8922;
GO
--SetCABG01: B
UPDATE NACRS_Project
SET DataField3 = 8921
WHERE ProjectNumber = 131
  AND DataField1 = 8881
  AND DataField3 = 8920;
GO

--SetCABG02
UPDATE NACRS_Project
SET DataField3 = 8921
WHERE ProjectNumber = 131
  AND DataField1 = 8882
  AND DataField3 = 8920;
GO

--SetHIPR01
UPDATE NACRS_Project
SET DataField3 = 8925
WHERE ProjectNumber = 131
  AND DataField1 = 8883
  AND DataField3 = 8924;
GO
--SetKNER01
UPDATE NACRS_Project
SET DataField3 = 8922
WHERE ProjectNumber = 131
  AND DataField1 = 8884
  AND DataField3 = 8921;
GO
--SetSHOD01
UPDATE NACRS_Project
SET DataField3 = 8924
WHERE ProjectNumber = 131
  AND DataField1 = 8885
  AND DataField3 = 8923;
GO
--SetSHOD02
UPDATE NACRS_Project
SET DataField3 = 8924
WHERE ProjectNumber = 131
  AND DataField1 = 8886
  AND DataField3 = 8923;
GO
--SetSTKE01
UPDATE NACRS_Project
SET DataField3 = 8923
WHERE ProjectNumber = 131
  AND DataField1 = 8887
  AND DataField3 = 8922;
GO
--SetSTKE02
UPDATE NACRS_Project
SET DataField3 = 8923
WHERE ProjectNumber = 131
  AND DataField1 = 8888
  AND DataField3 = 8922;
GO
