-- Sample only: standardize text/date formats in staging
UPDATE s
SET
    SourceName = UPPER(LTRIM(RTRIM(SourceName))),
    SourceUpdatedUtc = DATEADD(MINUTE, 0, SourceUpdatedUtc)
FROM dbo.Stg_SourceRaw s
WHERE s.LoadDtmUtc >= DATEADD(DAY, -1, SYSUTCDATETIME());