Here is my query. Sure do hope that I win Itzik's new book. - Mark

SELECT DoctorID, HospitalID

,CONVERT(varchar(40),PatientsYTD,1) AS PatientsYTD

...