Viewing 15 posts - 51,316 through 51,330 (of 59,072 total)
SQLZ (4/1/2008)
Jeff Moden (4/1/2008)
Ah ha! Finally! A challenge! If you would, post the resulting table creation script so I can duplicate what you have... the race is...
April 1, 2008 at 3:49 pm
matt stockham (4/1/2008)
This is very true ... except the stepping process should be done client side using the results of a set-based query.
Absolutely spot on!
April 1, 2008 at 3:48 pm
GSquared (4/1/2008)
April 1, 2008 at 3:43 pm
gr8scott_o (4/1/2008)
Seriously, I would pay $40 for this... problem is my snoring would probably give me away.
But wait! Don't order yet! If you're one of the next...
April 1, 2008 at 2:50 pm
Preet (4/1/2008)
Really!Do you think we got nothing better to do than read pointless articles?
Heh... well at least we know of one person who was going to buy it right...
April 1, 2008 at 2:42 pm
Matt Miller (4/1/2008)
Jeff Moden (4/1/2008)
Matt,Awesome. Can you post the test code? That sure sounds like a "keeper" to me.
You've already seen it... right here (sorry - forgot to...
April 1, 2008 at 2:34 pm
Rags, I've got one more "by the way"... you are using this just for a GUI passing parameters, aren't you?
If you're trying to split a whole column of CSV's, then...
April 1, 2008 at 2:31 pm
Rags (3/31/2008)
Jeff Moden (3/31/2008)
April 1, 2008 at 2:28 pm
J (4/1/2008)
Jeff Moden (4/1/2008)
Are you going to do that from a GUI where parameters are normally passed as CSV's?Er, is the question addressed to "Rags" or to "J" ?
Sorry... I...
April 1, 2008 at 2:25 pm
Outstanding set of posts on this thread, both pro and con! Thanks for the very interesting conversation and the testing that some of you have done! You guys...
April 1, 2008 at 2:19 pm
John Rowan (4/1/2008)
You should see how fast things run in the NV tables when you've had the time to add the proper indexes.
Thanks. For my example, I've only added...
April 1, 2008 at 2:17 pm
Moral: even if you decide to combine subtypes in the transaction table, write your SQL as if they were separate tables.
Heh... moral of the story should be that if...
April 1, 2008 at 2:15 pm
TheSQLGuru (4/1/2008)
1) most code doesn't actually GET reused because a) all devs don't know about it, b) devs don't bother checking to see if their...
April 1, 2008 at 2:11 pm
SQLZ (4/1/2008)
The trick is in knowing when to use them.
That is absolutely correct! The problem is that most people simply give up too soon!
When a developer comes to me...
April 1, 2008 at 2:01 pm
Heh... Karl... no wonder that it appears that your cursor beats the function... your cursor doesn't do the same thing/produce the same row set... I'm working on it...
April 1, 2008 at 1:35 pm
Viewing 15 posts - 51,316 through 51,330 (of 59,072 total)