Should you during an upgrade see this message
Then the mentioned migration script is the one below:
--Step 1: Priory to running the scrip backup database just in case
--Step 2: Run the following 3 Update Statements
UPDATE [@BOY_ABON] SET U_BOY_STY = ISNULL((SELECT TS0.ShipType FROM OCRD TS0 WHERE TS0.CardCode = U_BOY_FP),-1) WHERE U_BOY_STY IS NULL
UPDATE [@BOY_ABON] SET U_BOY_INDI = ISNULL((SELECT TS0.Indicator FROM OCRD TS0 WHERE TS0.CardCode = U_BOY_FP),'') WHERE (U_BOY_INDI = '' OR U_BOY_INDI IS NULL)
UPDATE [@BOY_ABON] SET U_BOY_DIS = (SELECT OCRD.Discount FROM OCRD WHERE OCRD.CardCode = U_BOY_FP) WHERE ISNULL(U_BOY_DIS,0) = 0
Please sign in to leave a comment.