December 3, 2001 at 4:16 pm
Functional is good! Figured I'd use the DMO code for something later anyway, so not entirely wasted effort.
Andy
December 3, 2001 at 5:42 pm
test reply
December 3, 2001 at 5:57 pm
Slow ass DMO coders!
BTW, as to the original question, do you ahve other tables that return quickly? Perhaps you are IO constrained.
Steve Jones
December 3, 2001 at 7:14 pm
>> I just used a while loop with a print statement in T-SQL ...
That's similar to my first solution. It's what I always do to create things manually as it's quick and lets you look at what you are going to run.
Cursors never.
DTS - only when needed and never to control.
December 3, 2001 at 8:39 pm
That is SO wrong Steve. Dumb maybe, but not slow!
Andy
December 3, 2001 at 11:06 pm
Cobol was a language where typing speed made a difference - looks like we're getting back to that.
As to the original question - I would go for the network or display being the problem.
Cursors never.
DTS - only when needed and never to control.
December 4, 2001 at 7:07 am
Nigel -
quote:
>> That's similar to my first solution. It's what I always do to create things manually as it's quick and lets you look at what you are going to run.
Yes, my solution was not far off from yours, you just took it the extra step farther to "wrap" it up nicer.
Did we lose SMC on this post?
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply