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,
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?