Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chrissyppppp
Starting Member
6 Posts |
 Posted - 2013-07-09 : 09:18:45
|
| Currently i have a requirement which needs a table to look like this:Instrument Long Short 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 .... Fixed 41 41 35 35 35 35 35 35 35 53 25 25Index 16 16 22 22 22 32 12 12 12 12 12 12Credits 29 29 41 16 16 16 16 16 16 16 16 16Short term 12 12 5 5 5 5 5 5 5 5 5 17My worktable looks like the following: Instrument Long Short Annual Coupon Maturity Date Instrument ID Fixed 10 10 10 01/01/2025 1 Index 5 5 10 10/05/2016 2 Credits 15 15 16 25/06/2020 3 Short term 12 12 5 31/10/2022 4 Fixed 13 13 15 31/03/2030 5 Fixed 18 18 10 31/01/2019 6 Credits 14 14 11 31/12/2013 7 Index 11 11 12 31/10/2040 8 ..... etcSo basically the long and the short in the pivot should be the sum of each distinct instrument ID. And then for each year i need to take the sum of each Annual Coupon until the maturity date year where the long and the coupon rate are added together.My thinking was that i had to create a while loop which would populate a table with a record for each year for each instrument until the maturity date, so that i could then pivot using an sql pivot some how. Does this seem feasible? Any other ideas on the best way of doing this, particularly i might need help on the while loop? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
While loop to create a pivot