SELECT 
'
update L
set L.UpdateBy = E.UserID,
 L.CreatedByID = E.UserID
from EmployeeProfile E
inner join ' + OBJECT_NAME(T1.object_id) + ' L on E.EmployeeID=L.UpdateBy
' AS cmd
FROM sys.columns T1
INNER JOIN sys.columns T2
ON T1.object_id = T2.object_id
WHERE T1.name = 'UpdateBy'
AND T2.name = 'CreatedByID'

update LocationMaster
set UpdateBy = CreatedByID
WHERE CreatedByID IS NOT NULL
--AND UpdateBy IS NULL --?? only where it's currently blank/null?