Viewing 15 posts - 5,911 through 5,925 (of 7,483 total)
Lowell (5/7/2011)
i would order by datetime, and never convert.you could use the COALESCE function to get the order you want i think; that would be the easiest:
ORDER BY COALESCE(ArrivalDate,BookingDate,DepositDate)
Since ArrivalDate...
Tom
May 8, 2011 at 2:55 pm
MHilsher (4/28/2011)
Tom
May 8, 2011 at 2:15 pm
Daniel Bowlin (4/27/2011)
Tom
May 8, 2011 at 12:12 pm
Nice easy question.
If there were more like this I would have a better score.
Tom
May 8, 2011 at 11:37 am
ChrisM@home (5/3/2011)
Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.
I'll second that suggestion. ...
Tom
May 7, 2011 at 3:43 pm
RAIN
I've seen more rain in the last two and a half days than in the previous five and a half months. I suppose I asked for it, coming back...
Tom
May 7, 2011 at 12:33 pm
Paul Randal (5/6/2011)
Tom
May 7, 2011 at 12:22 pm
Good question.
I got that one wrong by assuming that backup would be up-front about whether row and page compression had been included so that failure would be immediate. Now...
Tom
May 6, 2011 at 10:08 am
Nice question. I like it when the question is clear and the answer too, with no scope for arguing about what it means.
Subscription mirroring isn't all it should be,...
Tom
May 5, 2011 at 11:36 am
Peter Trast (5/4/2011)
Tom.Thomson (5/4/2011)
Yes, the dialect range is quite amazing and very interesting. Unfortunately everything is tending to even down towards a common grammar, a common vocabulary, and a common...
Tom
May 5, 2011 at 3:19 am
Peter Trast (5/4/2011)
Ray K (5/4/2011)
Tom
May 5, 2011 at 2:24 am
Peter Trast (5/3/2011)
Tom.Thomson (5/3/2011)
Ray K (5/3/2011)
Pachebel's CanonCockney's drop their aitches, but what English dialect drops its ells?
Estuary English - Ah want a gloss of miwk
Often falsely identified as a type...
Tom
May 4, 2011 at 9:28 am
Viewing 15 posts - 5,911 through 5,925 (of 7,483 total)