Apparently with some data types or some SQL versions, some columns may be duplicated with a sysname datatype. I've submitted an update to the original script, but it may take a few days for the update to be approved.
In the Results CTE
FROM tempdb.sys.columns AS C
INNER JOIN tempdb.sys.types AS T2
ON C.system_type_id = T2.system_type_id
change the ON clause above to this
ON c.user_type_id = t2.user_type_id
(A solid design is always preferable to a creative workaround)