Hi,

Maybe I'm missing something here, but why bother with a script?

Simply use the unpivot function and then query as normal:

WITH P

AS (SELECT EMPLOYID,

...