>Sounds like a single Query with UNION and where clauses to include / exclude events and/or programs.

Do you think including something like 1=0 in the where clause for the union is better than multiple case statements? Both select portions are very complex.