Thanks for the response. I assume you are talking about doing this via a query string. Unfortunately, i can't so this because of query string size limitations. I pass way...

ahh gees thanks guys I knew I left something stupid out.

Ok thanks guys all of your information was helpful.

Thanks

the view is as follows

CREATE VIEW [dbo].[VIEW_FACT_SALESDATA]

AS

SELECT * FROM [dbo].[Z_FACT_SALESDATA_2000]

UNION ALL

SELECT * FROM [dbo].[Z_FACT_SALESDATA_2002]

UNION ALL

SELECT * FROM [dbo].[Z_FACT_SALESDATA_2003]

UNION ALL

SELECT * FROM [dbo].[Z_FACT_SALESDATA_2004]

UNION ALL

SELECT * FROM [dbo].[Z_FACT_SALESDATA_2005]

UNION ALL

SELECT *...