Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Case with multiple then
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Case with multiple then
Divers
Thread ID:
01047563
Message ID:
01047563
Vues:
52
I have a case:

set @result =
case

when (@state = 'CA' or @state = 'WA' or @state = 'OR') and @plinid = 'PERDOM' then 0 "--set @reson = 'PERDOM product line not allowed in CA,WA, OR'"

when (@state = 'NY') and (@comcode = 'KR') and (@plinid <> 'DJAR' or @plinid <> 'DREAMS') and (@item not like '%LIP_%') then 0

else 1
end

I want to be able to set @result to 0 or 1, which works fine, but I also want to set another variable, for example

when this then 1 and 2

Not sure if I can do this. Any help would be appreciated, thanks!!!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform