Here's what the print @DynamicPivotQuery looks like.

SELECT dayworked,[Tom],[Dick],[Harry]

FROM tbldaysworked

PIVOT(max(fullday)

FOR name IN...