Struck gold with our Google search wording and now see this a fairly common
request. Don't know why we didn't find these earlier. Anyway, thanks for all
the feedback. We have set this up already and it works fine.
> >Can't seem to locate anything on this topic so I am querying the group.
> >Is there any way to perform an SQL SELECT statement from the returned
> >resultset of a stored procedure?
> >Select colA, colD, colH, colJ
> >from ( Exec 'SomeExistingStoredProcedure ''SomeParameter'' ' )
> >order by colA
> >This doesn't work but you should get the point.
> And more from Erland:
> Bob Barrows
> Please reply to the newsgroup. My reply-to address is my "spam trap" and I
don't check it very often.