Ignore the pevious query.

the correct query is

SELECT cte.vcrProgramGroupName,

cte.EclerxOffices,

cte.ECRLevel,

SUM(ISNULL(t2.TotalEmployees, 0))

FROM...

Hi,

Thanks for giving me the idea.

but I have modified the 2nd query a bit, for the expected result

SELECT cte.vcrProgramGroupName,

cte.EclerxOffices,

...