Viewing 15 posts - 3,796 through 3,810 (of 4,080 total)
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? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 28, 2009 at 4:21 pm
Ninja: That would be some seriously twisted googling at this point 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 28, 2009 at 2:36 pm
Viewing 15 posts - 3,796 through 3,810 (of 4,080 total)