Date: 01/18/06 (SQL Server)    Keywords: sql

Hi all,

I'm looking for a way to update a table based upon a recordset returned from a stored procedure.

It appears as if you can't join on the results from a stored procedure nor loop over those records using a cursor.

I will be the first to admit, I often miss things when combing through documentation, but I was hoping to use a join in an update statement (which I could do, but I would prefer not to duplicate the logic that I've already got stored in this stored procedure)

If anyone can offer any suggestions, I would be most greatful.


--gryff

EDIT: I'm using SQL Server 2000

Source: http://community.livejournal.com/sqlserver/40866.html