USE [ReportServer$PGCREP]

DECLARE @OldUserID uniqueidentifier
DECLARE @NewUserID uniqueidentifier
SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = 'centralpharma\C.Dorion-adm'
SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = 'CENTRALINFRA\ucilmlardf_adm'

SELECT @OldUserID, @NewUserID
--UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID