I used a lot dynamic stored procedure.I had to, because they aren't really my first choice- I find it hard to read and to debug.

Anyway it was a good article.