Hi all,

I have a (fairly complex) sproc that uses two temporary cursors to create its result set. Now, I'm informed that the output of this sproc must be able to be acccessed from a SQL view -- *without* using any temp tables or storing the output in a permanent table (this sproc must be performed dynamically as part of a monthly process).

Any ideas on how might I accomplish this?

TIA,