Dynamic Union of Tables

[MasterBlaster]

Hi I am developing an application in C# with MS SQL at backend .
My database has tables corressponding to every month named JAN2008 ,FEB2008 . I allow user to enter From Date and To Date from two calenders on the front end. Now i want to write a query which would dynamically Union all the tables which lie between the selected dates of calenders and give me only those records in the union which satisfy any particular condition.
Hope you would help me with this problem !

[ck9663]

Hi I am developing an application in C# with MS SQL at backend .
My database has tables corressponding to every month named JAN2008 ,FEB2008 . I allow user to enter From Date and To Date from two calenders on the front end. Now i want to write a query which would dynamically Union all the tables which lie between the selected dates of calenders and give me only those records in the union which satisfy any particular condition.
Hope you would help me with this problem !

Actually you have to build the dynamic query (sqlstring) on your front-end, so this is more of a C# question than an MS-SQL.Try posting it in C# forum. I'm not much of a C# programmer. I'll try to help you with a pseudo-code.

1. Using the date1 and date2 from the textbox and store it in variables but hardcode it as the first day of that month.

2. Loop while date1 <= date2

3. Inside the loop, build your query.

4. Execute your query.

I hope I'm making sense :)

-- CK

[Brad Orders]

Hi MasterBlaster

With the tables you have at the moment, the easiest solution is to use the C# approach suggested. However, I would suggest that, if possible, you look into changing your tables so that you have a "DateEntered" column. Then you don't have to change the database schema every month, and the query becomes a simple "BETWEEN" statement.

HTH