WHEN C.DATA_TYPE IN ('decimal', 'numeric', 'smallmoney', 'money') THEN 'Decimal' WHEN C.DATA_TYPE IN ('binary', 'varbinary', 'image') THEN 'Binary' ...
This code is based off the xml-parser here: https://github.com/segmentio/xml-parser. Please see that page for details of the JSON output. The parse function takes an ...