A sql code pasted here so it can be referred easily.

/*****************************************************************
Cursor Template

****************************************************************/
Declare @vendor_id int;
Declare @vendor_name varchar(10);

DECLARE curName CURSOR FOR
SELECT BusinessEntityID, Name FROM Purchasing.Vendor WHERE PreferredVendorStatus = 1 ORDER BY BusinessEntityID; –Replace this line to suit your needs

OPEN curName;

FETCH NEXT FROM curName INTO @vendor_id, @vendor_name;

WHILE @@FETCH_STATUS = 0
BEGIN

FETCH NEXT FROM curName INTO @vendor_id, @vendor_name;

END
CLOSE curName;
DEALLOCATE curName;