Can i use case to set a varaible? 1

[stephenk1973]

Am trying to write a stored procedure..

Sort of....

SELECT CASE @prmFlag
WHEN 'O' THEN
(select @prmTDate = @prmTDateOpen )
WHEN 'C' THEN
(select @prmTDate = @prmTDateClose )

END

Does not like the select ( or set)

All advice much appreciated.

Kind regards

Stephen

 

[bborissov]

Try:

SET @prmTDate = CASE @prmFlag
                     WHEN 'O'  THEN @prmTDateOpen 
                     WHEN 'C'  THEN @prmTDateClose
                ELSE
                     NULL 
                END

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[stephenk1973]

Works, much appreciated.