Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
How to change: update clientbalance set balance = (@balance - @amount) to If @transactiontype = 1 or 2 set @sign = '-' If @transactiontype = 3 or 4 set @sign = '+' update clientbalance set balance = (@balance @sign @amount)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.