Viewing 15 posts - 1 through 15 (of 16 total)
Whilst I enjoyed the mental exercise and learning something I didn't know about 2005, I just can't picture when I would actually do such a join in real life. ...
September 14, 2009 at 8:00 am
The final SQL didn't work for me, QA returned an error about the hyphen.
Also, I'm not that experienced but surely it's "case when" and not "casewhen" ?
June 30, 2008 at 7:24 am
Thanks Mark - SM.
April 1, 2008 at 7:28 am
Thanks David, I'll go buy the book now!
March 31, 2008 at 3:00 am
This article, and its many replies, is a great example of why I like this site so much! Valuable points are made, with time taken to describe exactly how...
March 12, 2008 at 4:28 am
Sorry, the notable word in my last post was 'update'. The running totals issue can be addressed in a number of ways outside a cursor. But what of...
January 3, 2008 at 4:09 am
Thanks for the Robyn Page Simple Talk article, I'm reading it now. There's a difference between needing to calculate a running total on the fly and having to calculate...
January 3, 2008 at 2:32 am
I needed to get a cumulative running balance column in a table. So I used a cursor. I'm not very advanced but it seemed like the only way...
January 3, 2008 at 1:57 am
OK, after my earlier rant, and having read the ensuing comments, I too will agree on the difference between 'consultant' and 'contractor'.
But why is it that we are arguing these...
November 9, 2007 at 7:01 pm
I haven't read the other responses so apologies if this repeats something that was said earlier (and better).
If you hired a plumber and they really didn't know their way around...
November 9, 2007 at 7:53 am
Still funny a year later! Just what I needed to 'zen out' after a hellish journey to work during a London Tube strike.
September 4, 2007 at 2:06 am
Hi - based on the dates of the other comments, I'm coming to the party a little late. But thanks for a very clearly-explained (and with two examples) piece of...
March 30, 2007 at 2:09 am
Gosh, some people can be very strident. "Just don't use nulls!" ? Really, show me the db that can be guaranteed to have a value in every row, every column. ...
February 26, 2007 at 6:59 am
Hi Ninja - wow, is that ever a good workaround! I've been focusing so much on the "woods" that I missed the "trees". Yes, of course by converting GETDATE() to...
December 20, 2006 at 8:33 am
Hi - let me start again, this might be easier:
1) Need today's date so use function GETDATE().
2) SQL Server only has datetime fields (no date-only...
December 20, 2006 at 7:42 am