Insert/Select Clause Syntax

[cmarch1]

Can anyone assist me with the following?

I'll write it generically so I can be assisted better
with (****) being the problem code

Insert into Grants
( id,type,requestdate,project,budgetdate)
Select
a1,'B',getdate(), @dd, (****)
from vw_test
Where fiscalyear = @intFY

(****) should be
IF GrantAmount is Null
Set @newbudgetamount = budgetamount
Else
Set @newbudgetamount = grantamount
end

I've tried different combinations but I always get an error message about syntax
even with begin/ends

 

[foxdev]

Try using a CASE construct rather than the IF block. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[cmarch1]

still having no luck

do you have an example of a CASE statement for

IF GrantAmount is Null
Set @newbudgetamount = budgetamount
Else
Set @newbudgetamount = grantamount
end

remembering I have to pass @newbudgetamount after I evaluate grant amount

 

[cmarch1]

After testing and debugging results, I got it.....thanks for the input