SHARE
TWEET

Untitled

a guest Aug 19th, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DECLARE @DISCOUNT_PRICE numeric(9,2) = '436.63'
  2. DECLARE @PRICE numeric(9,2) = '1.2'
  3. select CAST((((@DISCOUNT_PRICE*100)/@PRICE) -100 ) AS NUMERIC(5,2))
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top