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