Posted by: mero_naam_ho November 14, 2015
Login in to Rate this Post:
0
?
Here's the fiddle
http://sqlfiddle.com/#!6/9eecb7db59d16c80417c72/187
DECLARE
@PRICE INT = 100,
@TAXRATE FLOAT = 0.07,
@TAXAMOUNT FLOAT
SET @TAXAMOUNT = @PRICE * @TAXRATE
SELECT
@PRICE AS 'PRICE',
@TAXRATE AS 'TAX RATE' ,
@TAXAMOUNT AS 'TAX AMOUNT',
@PRICE + @TAXAMOUNT 'TOTAL PRICE'
Hope it helps
http://sqlfiddle.com/#!6/9eecb7db59d16c80417c72/187
DECLARE
@PRICE INT = 100,
@TAXRATE FLOAT = 0.07,
@TAXAMOUNT FLOAT
SET @TAXAMOUNT = @PRICE * @TAXRATE
SELECT
@PRICE AS 'PRICE',
@TAXRATE AS 'TAX RATE' ,
@TAXAMOUNT AS 'TAX AMOUNT',
@PRICE + @TAXAMOUNT 'TOTAL PRICE'
Hope it helps