Viewing 5 posts - 1 through 5 (of 5 total)
Nigel,
Yes, your tally approach is much faster. 100 ms vs 1400 ms on my machine.
Thanks,
Bill
August 28, 2009 at 7:13 am
#1046177
I agree with Rimvydas' approach.
And for performance concerns on CTEs on this particular problem, this gives all the years from 1753 to 9999 that have 3 Friday the thirteenths. ...
August 27, 2009 at 11:04 am
#1045702
slange (1/23/2009) Bill Coale (3/13/2008) Also truncate to midnight the start/end date and any date comparisons to the range I handle the end date solution a little differently....
slange (1/23/2009)
Bill Coale (3/13/2008) Also truncate to midnight the start/end date and any date comparisons to the range
Bill Coale (3/13/2008)
I handle the end date solution a little differently....
Yes, and I'm looking forward to...
January 23, 2009 at 9:12 am
#931861
For this date range technique, for the end date:
nextrow.PriceStartDate AS EndDate
I usually do:
dateadd(day, -1, nextrow.PriceStartDate) AS EndDate
Also truncate to midnight the start/end date and any date comparisons to the...
March 13, 2008 at 6:36 am
#788981
Your changes and alternatives to instead RSS stream the forums make sense.
I only read the the direct hyperlinks in the "In this Issue" section, namely:
Featured Articles, Editorial, and Featured...
September 27, 2007 at 8:30 am
#736751