...
INSERT into [database name].[dbo].[User Metadata]
([User SID],[Page ID],[Personalization ID],[Date],[Time],[Page Metadata Delta])
SELECT 'E25C01B9-190A-4CA0-8FA4-1C0B8E8EBC53', -- Copy to user
a.[Page ID],
a.[Personalization ID],
a.[Date],
a.[Time],
a.[Page Metadata Delta]
FROM [LP_DEV].[dbo].[User Metadata] a
WHERE a.[User SID] = '9EED4B7C-7748-4032-AF28-6B4092ADF90E' -- Copy from user
-- 9EED4B7C-7748-4032-AF28-6B4092ADF90E (User name)