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 !
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 !