Well,
I am going through one of my SRPOCs and I have some doubt about one of its values. It goes like this :
Now my question is:Code:Update tb_book SET stockbalance = stockbalance-@qty LimitAlert= Case When stockBalance-@qty<re_orderLimit THEN 1 ELSE 0 END
Is @qty being deleted twice , in the Set... and in the When.... ?





Reply With Quote