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

declare @contractType as int
DECLARE @generalTemplateID int
DECLARE @alertsTemplateID int

SELECT @contractType = (SELECT fldID FROM Deleted)

CASE @contractType
     when x then set @generalTemplateID = value1
     when y then set @alertsTemplateID = value2
     else then (something else)
END

Gracias!

Yuval Kronenfeld
Web Developer

That won't work.

In T/SQL, CASE is an expression which returns a value and is not a flow control construct as in other languages.

You'll have to execute IF/ELSE statement blocks to do what you want.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hi All,

Well actually i already figured it out myself:

declare @contractType as int
DECLARE @generalTemplateID int
DECLARE @alertsTemplateID int

SELECT @contractType = (SELECT fldID FROM Deleted)

SELECT @alertsTemplateID =
CASE @contractType
     when 1 then set value1
     when 2 then set value2
END

and the same for the second variable.
Thank you all anyway



Yuval Kronenfeld
Web Developer