Create VIEW Test as 

with cte as (select *, count(*) over (partition by driver, location, datepart(weekday, pickupdate), pickuptime) as cntTimesPerDay from DeliveryTable),
cte2 as (select *, row_number() over (partition by driver, location, datepart(weekday, pickupdate) order by cntTimesPerDay DESC) as Rn from cte)
select * from cte2 where Rn = 1 -- rows with most common times per day per driver/location

>Naomi...
>I've been trying to put this into a view, and can't find any way to do it.
>Can it be done?

Sure, try the syntax above.