|
|
Wednesday, January 18th, 2006
|
10:53a - First Time Poster
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
current mood:  frustrated (14 comments |comment on this)
|
|
|
|
