#DateForumTypeThreadPost
423 Mar 2015 @ 02:35 PDTDatabaseReplyUsing Case statement instead of UnionThanks for your reply @dnoeth ! I didn't want to use union because I was running out of spool space while using 3 unions. I'll try to optimise the union query and collect some stats to se...
322 Mar 2015 @ 09:18 PDTDatabaseTopicUsing Case statement instead of UnionI have a table which has data like: C1|C2|C3|C4 a||| |b|| ||c| |d|e|   I want output like   C --- a b c d e ...
220 May 2010 @ 03:14 PDTDatabaseReplyquery not giving desired resultAlso, using a where clause in left or right outer joins makes it an inner join...always keep your conditions in on clause
112 Mar 2009 @ 02:56 PDTUDATopicconvert varchar to timestampI have a column in source strdate1 as VARCHAR(23) and the value being '20090310181010'.I am unable to insert this record into target table column whose data type is timestamp(0) using this query wi...