#DateForumTypeThreadPost
415 Aug 2016 @ 05:13 PDTDatabaseTopicPerformance Issue - Left Join vs UpdateHi everyone, I have 2 tables as below:   Main (20 mil rows, 50 other columns): Col1  Col2  Col3 a       2      3 b       2   &n...
303 Apr 2016 @ 11:54 PDTDatabaseReplyRecursive Row FunctionCol2 is simplified but they are dates in numeric format (ie 20150215) and they increase on a yearly basis (next input will be 20160215) By that definition, Number of rows per col1 will be increasi...
203 Apr 2016 @ 04:54 PDTDatabaseReplyRecursive Row FunctionUpdated Rules (to make it clearer): If first row of new Col1, then Col4 = Col3 If not first row, If Col3 < PrevRow_Col4 then Col4 = (Col3 + PrevRow_Col4) / 2 ...
103 Apr 2016 @ 04:39 PDTDatabaseTopicRecursive Row FunctionHi guys, I have a situation as below: a    1    0.1 a    2    0 a    3    0 b    1 ...