Those are the basic procs that DataClas uses. There are other kinds of procedures that one would create manually. For example, I have a proc that accepts one input parameter and runs validation code. The result is 2 output variables. The first is a status code. The second is a status message.

The practice is anything but rare...


>Ok, this is the point that I was suggesting that you should have raised initially. Not to dwell to much on the 'rare' issue (is that what were talking about this time? :-)), but I did say _relatively_ rare. I see, for instance, that not a single SP in your DataClas sample database returns more than one output parameter, and most don't return any. In all of my personal experience as well as all the samples and tutorials from MS and other parties that I have seen, none employ multiple output parameters. I didn't say nobody uses them, I said that I think that the practice is _relatively_ rare.
>