I have a query that returns me data like what I have below...
NULL 2011-11-01 18:08:59.883
2011-11-02 03:01:45.843 NULL
I would really like to have:
2011-11-02 03:01:45.843 2011-11-01 18:08:59.883
I tried using Coalesce(Temp1_TS, Temp2_TS), but that gives me a single column with 2 rows. I need a single row, with 2 correctly named columns.