I have one stored procedure MySproc with following two queries
INSERT INTO STG
SELECT ID,AMT,DATE FROM CUSTOMER
UPDATE STG SET AMT = null
I dont want to run the update everytime I run MySproc. What is the best way to control what I want to run within MySproc?
Create your procedure as below
CREATE PROCEDURE myPROC @RUNUPDATE INT = 1
AS
BEGIN
INSERT INTO STG
SELECT ID,AMT,DATE FROM CUSTOMER
IF @RUNUPDATE = 1
BEGIN
UPDATE STG SET AMT = null
END
END
When you run call your proc, you can pass in a value of 1 or 0 depending upon whether you wish to run the update.
Try this script:
INSERT INTO STG
SELECT ID,AMT=NULL,DATE FROM CUSTOMER
INSERT INTO STG
SELECT ID,NULL,DATE FROM CUSTOMER
