Thank you all for your help , as i am new to sql i was not sure on how to run the updates as one update rather than six indivisual...

Hi Jared

Thank you for your help its much aprreciated

when i run the code i am getting the following error

Column 'cte.ClusterTrip' is invalid in the select list because it is not...

Hi Jared

Thanks for the reply i have moved my spaces and characters from my column names, sorry about the way i posted the question i will follow the guidelines next...

Sorry i posted the question before i completed it

1st Select Statement

Select BchCode,

SUM(localOffd) As 'Local Offd Calls',

Sum(LocalAns)...