#DateForumTypeThreadPost
612 Aug 2016 @ 08:36 PDTDatabaseReplyNeed help with interdependent calculation using result from previous rowAnyone? Surely this can be done?
508 Aug 2016 @ 12:02 PDTDatabaseReplyNeed help with interdependent calculation using result from previous rowWould a loop or recursive query apply to this scenario? If so, can someone please help me understand how this can be accomplished? 
404 Aug 2016 @ 03:25 PDTDatabaseReplyNeed help with interdependent calculation using result from previous rowDieter, 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...
304 Aug 2016 @ 12:16 PDTDatabaseReplyNeed help with interdependent calculation using result from previous rowkirthi, 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 ...
204 Aug 2016 @ 07:35 PDTDatabaseReplyNeed help with interdependent calculation using result from previous rowThank 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...
103 Aug 2016 @ 10:33 PDTDatabaseTopicNeed help with interdependent calculation using result from previous rowHi 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 ...