INSERT INTO [dmfiler] ([DocumentKey],[FolderKey]) SELECT [DocumentKey],'DESTINATION_FOLDER_ID' FROM [dmDocument] WHERE ([DocumentKey] NOT IN (SELECT [DocumentKey] FROM [dmFiler]))