The code below is for one month ie 201401.
Code: Select all
DECLARE @ID int
Set @ID = convert(varchar,
(
Select Id
From budget
Where period = 201401 --yyyymm
And bunit = '45'
And dept_no = '202'
And acct_no = '400000'
And prod_no = 'NoProd'
And scenario = 'budget'
)
)
IF @ID <> ''
BEGIN
UPDATE budget
SET Amount = 1200
WHERE Id = @ID
END
ELSE
BEGIN
INSERT INTO budget VALUES (201401, '45', '202', '400000', 'NoProd', 'Budget', 'Local', 1200)
END