mssql-cursor

DECLARE account_cursor CURSOR FOR Select name, revenue from
FilteredAccount
OPEN account_cursor
declare @name as varchar(160)
declare @revenue as money
FETCH NEXT FROM account_cursor INTO @name, @revenue
WHILE @@FETCH_STATUS = 0
BEGIN
-- do something here
print @name + ' ' + CAST( isnull(@revenue, '') as varchar(40))
FETCH NEXT FROM account_cursor INTO @name, @revenue
END
CLOSE account_cursor
DEALLOCATE account_cursor