SET NOCOUNT ON

SET NOCOUNT ON

DECLARE @PageGroupID int

DECLARE authors_cursor CURSOR
FOR SELECT PageGroupID FROM idoc_PageGroup

OPEN authors_cursor
FETCH NEXT FROM authors_cursor into @PageGroupID

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @PageGroupID
FETCH NEXT FROM authors_cursor INTO @PageGroupID

END
CLOSE authors_cursor
DEALLOCATE authors_cursor

~ by ttdoanst on April 18, 2007.