Using the MRP Explosion Stored Procedure

— To turn on Stored Procedure MRP
IF EXISTS (SELECT * FROM CompanySettings WHERE KeyName = ‘UseMRPStoreProcedure’)
BEGIN
UPDATE CompanySettings SET BVal = 1 WHERE KeyName = ‘UseMRPStoreProcedure’
END
ELSE
BEGIN
INSERT INTO CompanySettings (KeyName, BVal) VALUES (‘UseMRPStoreProcedure’, 1)
END

— To turn off Stored Procedure MRP
IF EXISTS (SELECT * FROM CompanySettings WHERE KeyName = ‘UseMRPStoreProcedure’)
BEGIN
UPDATE CompanySettings SET BVal = 0 WHERE KeyName = ‘UseMRPStoreProcedure’
END