Unanswered: Can I manipulate the result set of a sproc?
I need to call a sproc but just return a couple of the columns in the result set. I can't alter the original sproc. Is this possible? Something like the following would be great but I don't think it's possible:
select col1, col3 from ( exec the_sproc )
I can obviously create a copy of the sproc and just alter the output or put the output in a separate table before selecting out or just call from PERL etc and manipulate the output there but "they" don't want that.