so

IF @ApplicationName = 'MAC'

BEGIN

SELECT NetworkName, SampleTime, [Max] FROM vinny..PerfData_CPUServerView (nolock)

Where NetworkName in (@ServerName)

And SampleTime >= @StartDateTime and SampleTime <= CONVERT(date, DATEADD(dd, 1, @EndDateTime), 101)

Order by SampleTime asc

END

ELSE

BEGIN

select NetowrkName.SnapshotTime, ProcessUsePct from vinny..SqlResourceUseHistoricView (NOLOCK)

Where B.NetworkName in (@ServerName)

And Snapshottime >= @StartDateTime and SnapshotTime <= CONVERT(date, DATEADD(dd, 1, @EndDateTime), 101)

Order by SnapshotTime asc

END

Didn't work for you?