Cursor with stored procedure as source 1

[grnzbra]

I have a stored procedure which, when called from the query analyzer, gives a set of records.

My understanding of a cursor is that it is declared sort of as follows:

DECLARE csrDesk CURSOR
LOCAL
FORWARD_ONLY
STATIC
READ_ONLY
FOR
SELECT d.Desks, d.Average_Desk_Cost
FROM Desk_Costs d
WHERE d.Office_No = @OffNo AND MONTH(d.Desk_Date) = MONTH(@EnDt) AND YEAR(d.Desk_Date) = YEAR(@EnDt)

 

[ESquared]

After some reflection I don't think what you want done can be done with set-based processing.

Good luck!

 

[grnzbra]

It does work. I put a "Print" statement at various points in the loop and could see each record being processed.

 

[ESquared]

You are using a loop... not set operations.

 

[grnzbra]

Set operations?

 

[ESquared]

Set-based operations:

[tt]UPDATE Table SET Field = Expression WHERE Condition[/tt]

Loop-based operations:

[tt]For i = 1 to 100
Update Record #i With Expression
Next[/tt]

 

[grnzbra]

Got it. Thanks!