>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.
If it's not broken, fix it until it is.
My Blog