Viewing 15 posts - 2,896 through 2,910 (of 4,080 total)
My rating should be "Threadhead" instead of Ten Centuries, but I'm making it a point to spend more time answering questions than "chatting" here in The Thread. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 9:14 am
I wasn't going to say it, Jeff. 🙂
If all the function is used for is to find a single date (like the first...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 9:11 am
Also keep in mind that normalisation is a logical concept, not a physical one.
Multiple indexes and summary tables are everyday examples of redundancy that don't seem 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
April 29, 2009 at 8:46 am
Is this....?
Nevermind.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 8:05 am
.... and a novel thought...
Why not just have the nested proc return those two values as output parameters itself, rather than as a two-column, one-row result set? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 7:57 am
And the secret ingredient is . . . . you have to use a cursor!
jc 🙂
I'm so happy someone else has seen that show. I loved the original...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 7:30 am
This came up in another thread. You can find a couple of competing solutions here.
Basically, you can run an IF Exists with your query to see if there...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 7:07 am
Hey... what's an "UPDATE" ?? Can I use it to increment a date?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 6:50 am
It was new in 2005, Matt. 🙂
Cross Apply and Outer Apply also work very well with table-valued functions.
If the function is an inline (single query)...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 29, 2009 at 6:45 am
It really is.... 😉
ESPECIALLY for the classic... "I need all the data from the row that has max([col])."
Try it, you'll like it.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 4:30 pm
Sounds like a good idea to me, Bruce.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 4:06 pm
Also, I used Cross Apply because I believe it's going to produce a more efficient execution plan for you. Please let me know how it performs with your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 4:04 pm
You shouldn't need all three. The first two are both summary queries with the same search criteria, and could be combined. You could also combine subqueries...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 3:54 pm
Albatross
I shook him off from my neck a long time ago, O Ancient Mariner. 😎
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 3:35 pm
And bring us... a shrubbery!!
NI!
Shhhhh....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 28, 2009 at 3:14 pm
Viewing 15 posts - 2,896 through 2,910 (of 4,080 total)