mstoini
Grasshopper
Points: 14
More actions
July 1, 2003 at 1:44 pm
#160267
is this possible?
if
( 50-
(if (@var1>4)
select 0
else
select 10
)
)>=0
select @var1
guarddata
SSCertifiable
Points: 6583
July 1, 2003 at 3:46 pm
#463840
You can use CASE
if ( 50 - CASE WHEN @var1 > 4 THEN 0 ELSE 10 ) >= 0
Guarddata-
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply