Information générale
Forum:
Microsoft SQL Server
Titre:
Case with multiple then
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement