How do I loop through a set of records in SQL Server?

by

By using T-SQL and cursors like this : 

DECLARE @MyCursor CURSOR;
DECLARE @MyField YourFieldDataType;
BEGIN
    SET @MyCursor = CURSOR FOR
    select top 1000 YourField from dbo.table
        where StatusID = 7      

    OPEN @MyCursor 
    FETCH NEXT FROM @MyCursor 
    INTO @MyField

    WHILE @@FETCH_STATUS = 0
    BEGIN
      /*
         YOUR ALGORITHM GOES HERE   
      */
      FETCH NEXT FROM @MyCursor 
      INTO @MyField 
    END; 

    CLOSE @MyCursor ;
    DEALLOCATE @MyCursor;
END;

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to get a particular preceding value of a column in SQL [closed]
  3. How to select just the row in the second table?
  4. Need SQL Script
  5. SQL update from one Table to another based on a ID match
  6. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  7. SQL JOIN vs IN performance?
  8. Can a foreign key be NULL and/or duplicate?
  9. How to generate a range of dates in SQL Server
  10. SQL RANK() versus ROW_NUMBER()
  11. Generate SQL Create Scripts for existing tables with Query
  12. SQL Server 2005 How Create a Unique Constraint?
  13. Check if a row exists, otherwise insert
  14. Export SQL query data to Excel
  15. Insert Picture into SQL Server 2005 Image Field using only SQL
  16. Execute Stored Procedure from a Function
  17. How do I use ROW_NUMBER()?
  18. sql server select first row from a group
  19. How to check if a string is a uniqueidentifier?
  20. CTE error: “Types don’t match between the anchor and the recursive part”
  21. How do I remove extended ASCII characters from a string in T-SQL?
  22. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  23. How to sum up time field in SQL Server
  24. Create parameterized VIEW in SQL Server 2008
  25. How to correctly insert newline in nvarchar [duplicate]
  26. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  27. Add a column to existing table and uniquely number them on MS SQL Server
  28. How to execute a stored procedure inside a select query
  29. How to Execute SQL Query without Displaying results
  30. SQL Inner Join On Null Values

Leave a Comment