Jason,

Check this out!

Someone provides the ability to deal with a parameter list rather than a single parameter.

http://sqlblog.com/blogs/greg_low/archive/2008/08/13/data-driven-subscriptions-in-sql-server-2005-standard-edition.aspx