• ChrisM@Work (9/17/2012)


    When you've read through that, read this excellent alternative by Dwain Camps[/url].

    But if you are really using SQL 2005, you're going to have to replace the values with the select ... union all select syntax.