Yes, I tried that first. It really should work. I'm not using Enterprise because my company won't buy it. It looks like we're stuck with dynaimc SQL.

Thanks, but option 1 is no good for us because we need to use stored procedures (your option 3). And that option results in the same problem. Using...

The partitioned view (pvF_Call_Level1) unions several tables that have ClientID as the column with the check constraint.

The queries:

Without variable--works. Query plan shows 1 table accessed

select dateID, count(*)

from...