# | Date | Forum | Type | Thread | Post |
6 | 12 Aug 2016 @ 08:36 PDT | Database | Reply | Need help with interdependent calculation using result from previous row | Anyone? Surely this can be done?
|
5 | 08 Aug 2016 @ 12:02 PDT | Database | Reply | Need help with interdependent calculation using result from previous row | Would a loop or recursive query apply to this scenario? If so, can someone please help me understand how this can be accomplished?
|
4 | 04 Aug 2016 @ 03:25 PDT | Database | Reply | Need help with interdependent calculation using result from previous row | Dieter, you're right that this would work in the example given, but there are some instances where there are gaps between the end_date and the next sell_date, in which case I need to use the se... |
3 | 04 Aug 2016 @ 12:16 PDT | Database | Reply | Need help with interdependent calculation using result from previous row | kirthi, unfortunately that results in the same problem. The second row is ok, but the third row fails to reference the previous row's adjusted end_date, so the adjusted sell_date occurs before ... |
2 | 04 Aug 2016 @ 07:35 PDT | Database | Reply | Need help with interdependent calculation using result from previous row | Thank you for your input, Kevin. Your suggestion of using partition by and preceding was what I had come up with and doesn't work, the problem being that it needs to look at the calculated valu... |
1 | 03 Aug 2016 @ 10:33 PDT | Database | Topic | Need help with interdependent calculation using result from previous row | Hi all, I've run into a problem that I'm having a hard time solving in Teradata. I have a query that returns a cust_id along with sell_date and a date_span (number). From that one date and ... |
|
|