I had a more complicated IIF statement in an access database that I needed to convert to a stored procedure. The IIF statement was

IIf([SrvDisc]=0 Or IsNull([SrvDisc]),IIf([Disc_Service]=0,0,[Price]*[Disc_Service]),[Price]*[SrvDisc]) As Disc

Not only is...