Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours
A catalog of around 3000 product configurations arrives as XML. Depending on the equipment, a configuration carries different and additional attributes, around a thousand across all variants. In an earlier project, the evaluation of such a catalog ran in application code: a loop over the object types, inside it a loop over the attributes, plus … Read more