Thanks for the help, but I have received a working solution from sqlteam.com

This new line produced a syntax error near distinct:

select count(distinct Left(ToName,2)) OVER(PARTITION BY TransTime, DriverNo) as CustCount

I had to write it as:

select distinct count(Left(ToName,2)) OVER(PARTITION BY TransTime, DriverNo) as CustCount

You...

Sorry, I accidentally posted before the message was complete.

So, I have this query:

select ROW_NUMBER() OVER(PARTITION BY TransTime, DriverNo ORDER BY TransTime) as CustCount

,...