Very Computer

UPDATE Table1 SET FieldName = 'somevalue' WHERE ID IN (SELECT Table2.ID FROM
Table2 WHERE Table2.FieldName2 = 'someothervalue')

But so far I've had no luck doing a similar thing with a stored procedure.
Is this at all possible?

    Paul

Quote:> I'm sure this is a very common question, but I searched Google for about
30
> minutes and couldn't find an answer.  I have a situation where I need to
get
> a result set, then execute a stored procedure using each record in that
> result set.  Is there any way I can do this without a cursor? I've been
able
> to do an update like this using WHERE...IN, like this:

> UPDATE Table1 SET FieldName = 'somevalue' WHERE ID IN (SELECT Table2.ID
FROM
> Table2 WHERE Table2.FieldName2 = 'someothervalue')

> But so far I've had no luck doing a similar thing with a stored procedure.
> Is this at all possible?

For an update statement, SQLServer will create one big plan for making all
of the changes, so it's important not to use a cursor.  For a stored
procedure, SQLServer will have to run the procedure N times anyway, so
there's no benefit in avoiding the cursor.

David

Quote:

> There is no way to do this without a cursor, and no reason to try.

> For an update statement, SQLServer will create one big plan for making all
> of the changes, so it's important not to use a cursor.  For a stored
> procedure, SQLServer will have to run the procedure N times anyway, so
> there's no benefit in avoiding the cursor.

> David

    Paul