커서 이용하기

DECLARE
 @StaticMenuId numeric,
 @My_Cursor  CURSOR

SET @My_Cursor = CURSOR LOCAL SCROLL FOR
select top 10 StaticMenuID from 
(Select staticmenuid, Max(LastUpdateDate) LastUpdateDate From imagedata where datakind=3 Group By staticmenuid) x
order by LastUpdateDate desc

-- 커서를 Open한다.
OPEN @My_Cursor

-- Open한 커서에서 정보를 가져온다.
FETCH @My_Cursor INTO
 @StaticMenuId
WHILE @@FETCH_STATUS = 0
BEGIN
 insert into mainstaticmenuupdate(staticmenuid, lastupdatedate)
 VALUES (@StaticMenuId, getdate())
 
 FETCH @My_Cursor INTO
  @StaticMenuId
END
CLOSE @My_Cursor
DEALLOCATE @My_Cursor
GO