Hello,
I have a variable value.Inned something like this
Select col1,col2,@var
from...
where...
The problem is i need to calculate values for @var ,
If col2='A' then @var = col1+10%
else col2='B' then @var=col1-8%
I know I have to use case statemnt but where? In select or where.
Please advice
Thanx
I have a variable value.Inned something like this
Select col1,col2,@var
from...
where...
The problem is i need to calculate values for @var ,
If col2='A' then @var = col1+10%
else col2='B' then @var=col1-8%
I know I have to use case statemnt but where? In select or where.
Please advice
Thanx