@CadeRoux does non-procedural mean catch-all custom tvfs are out?

@PeterVandivier Those are probably fine, but by that point, I can probably just use the Microsoft master data assembly and apply an XSLT.

Thanks for the link, it was a hard thing to search on

The posted answer is aces imo

Anything with xquery is always gonna be a bear. If you can’t generalize the solution from that answer for your case, then xquery is probably just too much effort for the output