Depreciation Calculation Through SQL

May 21 2016 3:20 AM

I have table called asset

Columns are

Item_Desc

Po_Date

Po_Amount

No.ofDepr.OverYear

AnnuallyDep

What i want to Show the depreciation every year

Data what i have is

Example

Below is the data what i have

ItemDesc PO_Date Po_Amount No.ofyeardep DeprByYear

A 01-Jan-2012 100,000 10 10,0000 10

i want below o/p

ItemDesc PO_Date Po_Amount No.ofyeardepYear DeprByYear

A 01-Jan-2012 100,000 2012 10,0000

A 01-Jan-2012 100,000 2013 10,0000

A 01-Jan-2012 100,000 2014 10,0000

A 01-Jan-2012 100,000 2015 10,0000

A 01-Jan-2012 100,000 2016 10,0000

A 01-Jan-2012 100,000 2017 10,0000

A 01-Jan-2012 100,000 2018 10,0000

A 01-Jan-2012 100,000 2019 10,0000

A 01-Jan-2012 100,000 2020 10,0000

A 01-Jan-2012 100,000 2021 10,0000

A 01-Jan-2012 100,000 2022 0

Answers (1)