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

