I have not updated to 0.31.2 yet. I need too. And I will dig into that after I update. Thank you for the heads up. It might not be pretty but this is what I came up with. I'll share in case you have an opinion. I wrote a new query. It's a bit of a mess and might be over complicated but, it works. Thank you very much again for all the help. I'll come back after I get the upgrades in and let you know what I find.
DECLARE @FirstDay SMALLDATETIME
DECLARE @LastDay SMALLDATETIME
SET @FirstDay = DateAdd("d",-30,GETDATE())
SET @LastDay = DateAdd("d",+1,GETDATE())
SELECT [DateTime], MeterID, KWH FROM (SELECT TOP(1) DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) AS [DateTime],p_mtrid AS [MeterID],p_usage AS [KWH] FROM dbo.utsProfile WHERE ((p_mtrid IN ('D8729M')) AND (p_mtrchn = 1) AND (DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) BETWEEN (@FirstDay) AND (@LastDay))) ORDER BY KWH desc) D8729M UNION
SELECT [DateTime], MeterID, KWH FROM (SELECT TOP(1) DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) AS [DateTime],p_mtrid AS [MeterID],p_usage AS [KWH] FROM dbo.utsProfile WHERE ((p_mtrid IN ('D8726M')) AND (p_mtrchn = 1) AND (DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) BETWEEN (@FirstDay) AND (@LastDay))) ORDER BY KWH desc) D8726M UNION
SELECT [DateTime], MeterID, KWH FROM (SELECT TOP(1) DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) AS [DateTime],p_mtrid AS [MeterID],p_usage AS [KWH] FROM dbo.utsProfile WHERE ((p_mtrid IN ('D8728M')) AND (p_mtrchn = 1) AND (DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) BETWEEN (@FirstDay) AND (@LastDay))) ORDER BY KWH desc) D8728M UNION
SELECT [DateTime], MeterID, KWH FROM (SELECT TOP(1) DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) AS [DateTime],p_mtrid AS [MeterID],p_usage AS [KWH] FROM dbo.utsProfile WHERE ((p_mtrid IN ('75273')) AND (p_mtrchn = 1) AND (DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) BETWEEN (@FirstDay) AND (@LastDay))) ORDER BY KWH desc) ID75273 UNION
SELECT [DateTime], MeterID, KWH FROM (SELECT TOP(1) DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) AS [DateTime],p_mtrid AS [MeterID],p_usage AS [KWH] FROM dbo.utsProfile WHERE ((p_mtrid IN ('75278')) AND (p_mtrchn = 1) AND (DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), CAST(SUBSTRING(p_dtm, 1, 4) + '-' + SUBSTRING(p_dtm, 5, 2) + '-' + SUBSTRING(p_dtm, 7, 2) + ' ' + SUBSTRING(p_dtm, 9, 2) + ':' + SUBSTRING(p_dtm, 11, 2) AS SMALLDATETIME)) BETWEEN (@FirstDay) AND (@LastDay))) ORDER BY KWH desc) ID75278