• Do you have a paritioned table or a partitioned view? Can you post the scripts for what you have, so that we can understand what you are talking about?

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]