>Borislav,
>
>>O, I see, you need both S Ps but sometimes you need only @@ROWCOUNT from S P 1, and you don't want to use Table variables. I'm thinking, I'm thinking... :-)
>
>Yes.
>
>I wish I could do something like this in the Count SP:
>
>
>select OneColumn
> from exec SP1
>
Sorry,
I couldn't figured out how to get rid of immediate recordset w/o redirecting it to something else. If the first S P doesn't return so many fields use a table variable to insert that recordset. If you find something more beautiful, please let me know.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
