Posted by Doug on 12/12/05 03:10

I can't speak to sql 2005, but anything previous, I'd TOTALLY support
what Mr. Sommarskog said.

Use a cursor. Much better in the long run, medium run, and short term.
Also, be sure to document what it is the INTENDED purpose of the sproc
is!!!

• Next in forum: Re: 1 SP with dynamic input parameters and multiple rows as the source of the query
• Prev in forum: Re: Select *
• Thread view: Re: Is this an efficient way to create a comma string

[Reply to this message]