SQLServerでWhileループを使う

DECLARE cur CURSOR FOR
SELECT DATA_ID FROM YOUR_TABLE;
OPEN cur
FETCH NEXT FROM cur
INTO @dataId

WHILE @@FETCH_STATUS = 0
BEGIN
--
        INSERT INTO YOUR_TABLE2
               ([DATA_ID]
               ,[OTHER_COLUMN])
         VALUES
               (@dataId
              ,'otherdata');
--
   FETCH NEXT FROM cur
   INTO @dataId
END

CLOSE cur
DEALLOCATE cur