BR><BR>The simple method would appear to be using SQL Server's SSIS Data Flow Task with XML as a source [edit: more specifically, using the XML Task]. However, the XML in question is backed by 8MB ...

I'm going to be building out a new web app soon, and it's large enough that I actually will want to plan out the user flow as well as database structure. Last time I did this via software was ...

SQL has dominated data querying for decades ... Simple features like variables reduce repetition and simplify the flow. The results from one line are fed into the next line in a long chain.