I figured it out. Thanks a ton.
IF OBJECT_ID('TEMPDB..#CPUUsage')IS NOT NULL
DROP TABLE #CPUUsage
CREATE TABLE #CPUUsage(NetworkName varchar(20),startTime Datetime,Value int)
Insert INTO #CPUUsage
SELECT NetworkName,SampleTime, [Max] FROM Singularity.dbo.PerfData_CPUServerView (nolock)
Where NetworkName in (@ServerName) And SampleTime >= @StartDateTime and SampleTime <= CONVERT(date, DATEADD(dd, 1, @EndDateTime), 101)
UNION
Select NetworkName,SnapshotTime, ProcessUsePct from Singularity.dbo.SqlResourceUseHistoricView (NOLOCK)
Where NetworkName in (@ServerName) And Snapshottime >= @StartDateTime and SnapshotTime <= CONVERT(date, DATEADD(dd, 1, @EndDateTime), 101)
order by 2 asc
Select * from #CPUUsage where Networkname = @ServerName