Posted by serge on 11/24/06 04:26

> To your question: if you need to return different sets of columns under
> different circumstances, I'd use different stored procedures for each
> result set.

This was one of the options we considered before going with the method
we want to use.

> The use of dynamic SQL as in your example has some downsides
> and some risks that you should avoid if at all possible.
>
> See http://www.sommarskog.se/dynamic_sql.html

We will continue to consult this great article as we continue
working on this project.

Thanks Hugo.

• Next in forum: Re: math error
• Prev in forum: Re: How to build a procedure that returns different numbers of columns as a result based on a parameter
• Thread view: Re: How to build a procedure that returns different numbers of columns as a result based on a parameter

[Reply to this message]