#DateForumTypeThreadPost
713 Apr 2015 @ 03:16 PDTDatabaseReplyClassification of dates in different columnsBig thank you ! It works !
610 Apr 2015 @ 10:46 PDTDatabaseReplyClassification of dates in different columnsTriple checked the SQL ...and can not find the issue (the only thing I know is that the issue comes from the top 4 case when lines....because the rest of the sql runs fine... maybe due to my s...
510 Apr 2015 @ 02:56 PDTDatabaseReplyClassification of dates in different columnsThanks, Dieter. I tried this but get the error message 3706 'expected the word RESET or ')' after ORDER BY clause. Could sth be missing ? 
409 Apr 2015 @ 03:05 PDTDatabaseReplyClassification of dates in different columnsNo, I have version TD13.00 and DENSE_RANK is not recognized...  
309 Apr 2015 @ 01:42 PDTDatabaseReplyClassification of dates in different columnsoups.... Answered too fast... I found such results: Customer_id    Prod_1    Prod_2    Prod_3   Prod_4    Start_dt_prod_1&nbs...
209 Apr 2015 @ 01:30 PDTDatabaseReplyClassification of dates in different columnsThank you soooooo much, it works !!!  I am really impressed :-)
102 Apr 2015 @ 01:41 PDTDatabaseTopicClassification of dates in different columnsHello, I have 4 different products (1=having the product, 0 = not having the product) with each, a corresponding start date, in 4 different columns: For ex. Customer_id  Prod1&nbs...