If it works, and you've tested it on large (say million-plus rows) data sets and it performs well, then go with it.  If you're going to be using dynamic SQL later on, remember to guard against SQL injection.

John