Using cursors makes sense when they are needed. You can speed them up by using the FAST FORWARD parameters which only allows forward only reading of the cursor.

We use them a couple of times in our projects.


>Thanks for the info, Simplicio
>
>>Robert,
>>
>>Use CURSOR in T-SQL
>>
>>

>>
>>DECLARE Employee_Cursor CURSOR FOR
>>SELECT EmployeeID, Title FROM AdventureWorks.HumanResources.Employee;
>>OPEN Employee_Cursor;
>>FETCH NEXT FROM Employee_Cursor;
>>WHILE @@FETCH_STATUS = 0
>>   BEGIN
>>      FETCH NEXT FROM Employee_Cursor;
>>   END;
>>CLOSE Employee_Cursor;
>>DEALLOCATE Employee_Cursor;
>>GO
>>
>>