Increasing a dollar amont by a percentage

Question

how do I increase a dollar amount by a precentage

Answer 1

Hi,

Can you describe the expected resultset with table design? Do you want something similer to shown below?

with CTE
as
( select 2000 as yearNumber, 50 as amount
union all select 2001 ,100
union all select 2002 ,150)

select a.yearNumber,((a.amount - cast(b.amount as decimal(19,4)) )/ b.amount ) * 100 as increasePercentage
from CTE a
inner join CTE b on a.yearNumber -1  = b.yearNumber

---

-Chintak (My Blog)

Answer 2

how do I increase a dollar amount by a precentage

DECLARE @Amount MONEY = 1

SET	@Amount = @Amount * 1.15

SELECT @Amount

increase by 15%

---

Vishal Gajjar

Answer 3

Any progress?

---

Premature optimization is the root of all evil in programming. (c) by Donald Knuth

Naomi Nosonovsky, Sr. Programmer-Analyst

My blog