1
Answer

need not genitive values

select id,((@Paying_Days-@ATB)*15) 
case
when SM_Conveyance > 0 then SM_Conveyance
else 0
end
 how can i use case for that because no need minus values
ex :
1-2= -1 
  i want print as 0 

Answers (1)