#DateForumTypeThreadPost
629 Oct 2013 @ 09:26 PDTDatabaseReplyTranspose rows to columnsDieter,   Following the same thought pattern only using a reference table with more than one column .. would a cross join function better than inner joining ?  exampl :   Actual r...
523 Oct 2013 @ 12:30 PDTDatabaseReplyTranspose rows to columnsSarah,    I do use a similar process to Dieter's suggestion only i use a perm reference table and hard inner joins against tables with ~200 mil records and yes it works well. In fact...
423 Oct 2013 @ 10:06 PDTDatabaseReplyTranspose rows to columnsMy appologies Sarah I should have assumed that this was for large volumes of data. Dieter love the cross join suggestion and will have to look into using for a process I run that uses a reference ...
323 Oct 2013 @ 08:14 PDTDatabaseTopicProblems using LIKE ANY on TD 13.1 if(typeof(dstb)!= "undefined"){ dstb();} Recently we switched over to TD 13 . Previous code that contained statements with LIKE ANY('CRITERIA1%', 'CRITERIA2%', 'CRITERI...
223 Oct 2013 @ 07:36 PDTDatabaseReplyTranspose rows to columns if(typeof(dstb)!= "undefined"){ dstb();} i would think union would suffice .. ?   sel    t.id   ,t.name   ,'english' as subject   ,t.english...
105 Feb 2013 @ 08:04 PSTToolsTopicsql assistant 13.10 - Show definition window wont closeWe are using 13.10.0.7. after right clicking the table or view and selecting show definition the window opens and will not let us close it. Tried right clicking the left top window and choosing clo...