Advertisement
Guest User

Untitled

a guest
Sep 30th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. declare @incPercent decimal(5,2)
  2. begin
  3. if @incpercent < 0.1
  4. begin update orderdetails set value = value + (@incpercent/10) where value = value end else
  5. update OrderDetails set value = value + 1.1
  6.  
  7. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement