Viewing 15 posts - 3,796 through 3,810 (of 4,081 total)
Andrew Reilly (2/4/2009)
Another flaw with this solution is it doesn't handle adding a negative number of days which is just as important in my eyes
I wouldn't call it a flaw,...
February 4, 2009 at 2:58 pm
Hey Gaby, I'm still curious. Why would you want a uniqueidentifier for a row to ever be null, even if it isn't the primary key? ...
February 4, 2009 at 2:49 pm
Sorry, no weekends allowed in the table. Just holidays.
Michael, I'll be happy to do that for the test with your function.
Just paste it up when you...
February 4, 2009 at 2:35 pm
Clifford, why don't you start a new thread under one of the T-SQL forums for your question? It will get answered quickly. Use a subject line about...
February 4, 2009 at 12:00 pm
I challenge anyone to a benchmark:
1. a million rows of StartDate, BusinessDays, EndDate
2. update thistable set EndDate=YourFunction(StartDate,BusinessDays)
3. a table of holidays consisting of a single column Holiday containing the American...
February 4, 2009 at 11:52 am
I'm in complete agreement that there are a myriad of ways to accomplish this task.
Hey J, whose post are you responding to? I'm assuming it was mine. ...
February 4, 2009 at 11:32 am
It can be done without a computer, for that matter...
True enough, j, but then we wouldn't have jobs !! :w00t:
Seriously, the reason people make such a...
February 4, 2009 at 8:52 am
We also use the tally table/holiday table approach instead of a loop. It is blindingly fast.
We prepopulate the holiday table with weekends as well as holidays, like this,...
February 4, 2009 at 8:37 am
I keep trying to tell y'all that a whizbang fibre-optic laser beam DISassembler is preferable. Like the lightsabre it's an elegant weapon... not as clumsy or random as...
February 3, 2009 at 2:50 pm
According to the online help for the OVER clause:
PARTITION BY
Divides the result set into partitions. The window function is applied to each partition separately and computation restarts for each...
February 2, 2009 at 4:00 pm
It works like a charm. But may I ask why you are concerned that a guid be sequential? I ask because when there is a need to...
February 2, 2009 at 8:45 am
Hey Joseph,
The answer to your question follows, but a little discussion is in order. Please take a moment to look at how I set up the...
January 30, 2009 at 2:13 pm
Congratulations on your millionth member! This site DESERVES the membership growth. I have never seen a forum bring together such expertise, professionalism, and just plain...
January 29, 2009 at 5:41 pm
Maybe the machines have already gone further back in time and caused the implementation of CURSORS... or given someone the idea that relational database tables can and should resemble objects.
The...
January 29, 2009 at 9:53 am
What are the odds of this thread evolving into SkyNet? I have children and I am worried about their future.
January 28, 2009 at 4:21 pm
Viewing 15 posts - 3,796 through 3,810 (of 4,081 total)