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 |
|
thomailo
Starting Member
1 Post |
 Posted - 2012-09-20 : 20:21:08
|
| Hi SQL team I need your help on something.I have to deal with a huge data base with thousands of aggregation groups.I am dealing with a portfolio and I have to figure out 1.)the peak day within a year of the aggregation group(each aggreagation group consists of many days in a portfolio), 2.)the peak value of the aggregation group(each aggregation group also consists of many values) 3.)peak day within lifetime of each aggregation group and 4.)peak value within lifetime of each aggregation group.Lifetime refers to to the years of the portfolio it might be a 30 year portfolio for example.The columns names are the following: aggr__group, Time_Horizon and EPE.I have been told that It should be one query.I would really appreciate your help at this point because it is really important to me. Thomailo |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-20 : 23:17:13
|
| can you illustrate your scenario with some sample data and required output?without that its a bit difficult to understand your problem!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
PEAK VALUES