We can get the desired output using the following simple Query as well.

SELECT

O.OFFICEID,

O.STATEABBR,

STUFF((SELECT ',' + CAST(COUNTYNAME AS VARCHAR(8000)) FROM DBO.COUNTY...