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

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016