In the article you mentioned a 8000 chars limit of @variable for dynamic SQL. You can extend this to several variables like this:

EXEC (@var1 + @var2 + @var3)

(see BooksOnline)

Otherwise, great article.

Edited by - jcool on 03/18/2002 04:55:54 AM