Viewing 15 posts - 3,376 through 3,390 (of 4,080 total)
Great 🙂
I only learned about the speed of ITVFs in the last month or so, from someone else in here. The performance gains are enough to make...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 6:45 am
Thanks, Jeff.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 6:36 am
A couple of suggestions:
(1) To improve performance, rewrite your scalar functions as inline table valued functions. They run MUCH faster in queries that produce large result...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 10:48 pm
That's the best thing about rants, Sergiy 😀
Now I personally have no intention of visiting the aforementioned blog. But, according to Wikipedia...
Dataphor was originally created as a commercial...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 10:12 pm
I'm in the states, and the choice of beverage is secondary to the opportunity for a good conversation. Do you do caffeine?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 9:36 pm
I realized that one Mh is SSC Enthusiastic and the other is a Forum Newbie. Can we assume that the "Urgent Urgent" isn't really any more?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 9:28 pm
Guiness is better. Perhaps some day we'll have opportunity to knock back a pint or two, Lynn. First round is on me.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 9:24 pm
No cursor needed. I don't have your original data, so I'm using a table variable in my code below to mimic your output. The code below...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 9:14 pm
No, we aren't sure what you want your output to look like.
One field on a particular table is used for 4 different fields on the report; what differentiates each one...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 8:12 pm
Science is a b****, expediency is a w*****.
You call the language above a mark of maturity? Crass doesn't equal cool, and foul language isn't 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
March 16, 2009 at 7:34 pm
Hey Steve, you may need to implement some functionality to lock down Author's Names in the forums.
Something peculiar is going on here.
The thread was started by...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 7:16 pm
Took me a while to sort out the identities by join date.
The obvious question to ask is:
If the other Mh wasn't the person that started this thread, why did they...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 7:11 pm
I'm all for wine tours, but only if we include New Zealand and Australia as well. Maybe Argentina too. Obviously, I drink a lot from 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
March 16, 2009 at 4:13 pm
There are a couple of ways.
First, if you are running this from SQL Enterprise Manager, there is an option to include row headers when you send...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 4:08 pm
For convenience, you can also just calculate up to a specified stop date.
(You could just say
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2009 at 3:53 pm
Viewing 15 posts - 3,376 through 3,390 (of 4,080 total)