>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,

Can you convert this sproc into UDF that returns a table Data Type?