CTE

Using a Common Table Expression to produce a list of Views, Procedures, and Functions

How to get a list of SQL Server modules to refresh

Concatenating values from multiple rows into one string value via a Common Table Expression

Pretty cool little trick you've made there.With the help of an analytic function, I've fixed the ordering, and as a byproduct it also scales better:WITH ranked AS ( SELECT make,model,Rank() over (PARTITION BY make ORDER BY model) Rnk FROM MakeModel ),cte...