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