sql server programming: Dear All,

I suggest you consider replacing your cursor with set-based SELECT / UPDATE
/ INSERT / DELETE statements and/or replacing your SP with a view.

If you need help with a non-cursor solution then post then post the DDL for
your tables, post some sample data as INSERT statements and show your
required result.

To reference the output of an SP in another query you can either output the
result to a temporary table first or use OPENROWSET / OPENQUERY to call the
SP.

--
David Portas
------------
Please reply only to the newsgroup
--