Viewing 15 posts - 30,781 through 30,795 (of 59,102 total)
Dang, Tom. My apologies for missing your feedback on this one.
While I'm here, thank all of you again for the great posts you've all made on this subject.
And being...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 9:57 pm
As promised...
First, here's one version of a Calendar Table that I've used in the past. It' complete with some typical U.S.A. holidays and the two special columns I've talked...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 7:21 pm
No technical drawbacks that I'm aware of or have ever encountered. The biggest problems appear the next day. Remembering that you ran it and remembering why you ran...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 5:25 pm
As a bit of a side bar... I find out which server the existing code is running against and try to setup to capture the SQL it's generating by the...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 5:18 pm
Considering that SQL Server will use RAM as part of TempDB until it no longer fits, is this not a moot point on a system with a TB of ram?
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 5:12 pm
Gary Varga (3/12/2012)
Give an interviewee enough rope and they will hang themselves 😉
Heh... "It Depends". I normally spend most of my time in an interview interviewing the interviewer. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 5:07 pm
Kingston Dhasian (3/12/2012)
jean 93062 (3/12/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 5:00 pm
J Livingston SQL (3/12/2012)
dwain.c (3/12/2012)
I like being contrary so I have to ask, why are you using a calendar table?
cos of this q from Jeff
Jeff Moden (3/10/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 6:19 am
Eugene Elutin (3/12/2012)
siva 20997 (3/12/2012)
Would like to know if there is lot of differnce in the perfomance bitween
User Defined Functions (like what I have posted)
and system defined functions like...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 6:14 am
dwain.c (3/12/2012)
I like being contrary so I have to ask, why are you using a calendar table?
I'm with you and try to avoid having to reference a table if I...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2012 at 6:04 am
Ok... I can't hold it back any longer. I've been holding back a bit (a lot, actually). I've used calendar tables on the job since I first learned...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2012 at 11:18 pm
CELKO (9/23/2010)
I still prefer Julianizing the business days to make the math easier
I know it's an old post but absolutely spot on here, Joe. It makes life much easier...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2012 at 12:27 pm
J Livingston SQL (3/11/2012)
Jeff Moden (3/10/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2012 at 12:09 pm
siva 20997 (3/11/2012)
The last date of the previous month compared to 4/1/2012 is 3/31/2012 which is a Saturday. According to the OP's requirements, it should return the next weekday after...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2012 at 8:57 am
Ok... my turn for a question, folks. Does anyone have a way to do this particular task using a Calendar Table? It doesn't even have to include holidays....
--Jeff Moden
Change is inevitable... Change for the better is not.
March 10, 2012 at 4:08 pm
Viewing 15 posts - 30,781 through 30,795 (of 59,102 total)