I think this is an interesting and useful example so long as you know enough to not use it as is in real life 🙂

The xml scripting with CTE is very interesting and I think the concept should prove useful in isolated situations, just don't go and blindly apply this to a database without testing it out or you will drown in a slow database with a ton of data.