select case
Hi all,
I have a trigger in which I retrive a certain value into a veriable.
Then based on the value of this variable I want to set the values of two other veriables (i.e. if variable=1 then variable1=10,variable2=20;if variable=2 then variable1=34,variable2=46).
I want to use something like select case clause.
These are the variables :
SELECT @contractType = (SELECT fldID FROM Deleted)
DECLARE @generalTemplateID int
DECLARE @alertsTemplateID int
how do I do it ?
Thanks,
Yuval Kronenfeld
Web Developer
__________________
Yuval Kronenfeld
Israel
|