2012-02-14 17:37:00
DECLARE @value INT

DECLARE @cursor CURSOR
SET @cursor = CURSOR FOR SELECT value#
                         FROM myTable

OPEN @cursor 
FETCH NEXT
FROM @cursor 
INTO @value
WHILE @@FETCH_STATUS = 0
BEGIN

    PRINT @value


    FETCH NEXT
    FROM @cursor
    INTO @value

END
CLOSE @cursor
DEALLOCATE @cursor
Copyright © 2024 delaney. All rights reserved.