Viewing 15 posts - 46,201 through 46,215 (of 59,062 total)
Tom.Thomson (1/1/2009)
Jeff Moden (12/31/2008)
January 1, 2009 at 12:14 pm
Bob Hovious (12/31/2008)
Who was it that defined legacy code as the stuff that has been around so long that you finally got most of the bugs out of it?
I don't...
January 1, 2009 at 12:06 pm
I think everyone would abuse a "Challenges" forum... might as well label it the "Urgent" forum. 😀
January 1, 2009 at 12:00 pm
RBarryYoung (12/31/2008)
Actually, Jeff, you should be using SQL_VARIANTS for the V part. That's what they're there for.:D
Uh huh... and someday they'll make all our dreams come true by making...
January 1, 2009 at 11:55 am
Make no doubt about it... Cursors are an advanced subject and no new user of T-SQL should be allowed anywhere near a cursor or any other form of RBAR until...
January 1, 2009 at 11:46 am
Fellow who goes by the handle "Fraggle" posted a function at the following URL... it seems to work quite reliably for the days ahead that I tested it for...
http://www.sqlservercentral.com/Forums/Topic153606-203-3.aspx#BM591629
December 31, 2008 at 7:55 pm
andrewd.smith (12/23/2008)
DECLARE @days int
SELECT @days = 10
DECLARE @inputDate datetime
SELECT @inputDate = '2008-12-23'
DECLARE...
December 31, 2008 at 7:13 pm
Fraggle (10/24/2008)
Alright, now that I have had a little time to ponder the imponderable as my dad would say, I figured out how to add X number of business days...
December 31, 2008 at 7:03 pm
paulhunter (12/31/2008)
Jeff Moden
Nope... haven't written one on dates, yet. Wrote one on how to do dynamic crosstabs using dates, but not one just on dates.
Robyn Page wrote a...
December 31, 2008 at 6:07 pm
RBarryYoung (12/31/2008)
Huh. and here I always use 121.
But not for trying to find a whole date...
December 31, 2008 at 5:59 pm
Michael Valentine Jones (12/31/2008)
where Convert(varchar, CreationDate, 101) between Convert(datetime,@FromDate, 101) And Convert(datetime, @ToDate, 101)
which can amount to something like this:
where '12/30/2008' between '12/25/2008' And...
December 31, 2008 at 4:13 pm
Ninja's_RGR'us (12/31/2008)
Hey Jeff, that's a great topic for a couple of articles... can't wait to read those!
Actually, that's not a bad idea, Remi... there's a lot of people, especially new...
December 31, 2008 at 4:08 pm
RBarryYoung (12/31/2008)
The irony of course is that if SUM(..) OVER(..) allowed ORDER BY, 2/3rds of the uses for it (the Update pseudo-cursor) would disappear.
Heh... how very true... and that's the...
December 31, 2008 at 4:02 pm
This is why we warned you that you shouldn't mess with systems table data directly... but if you insist on taking a chance especially without doing the necessary research (as...
December 31, 2008 at 3:57 pm
Viewing 15 posts - 46,201 through 46,215 (of 59,062 total)