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...
MasterBlaster
Last Activity: Mar 6 '08, 06:36 AM
Joined: Mar 6 '08
Location:
-
Dynamic Union of Tables
-
Dynamically Union of Tables
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...
No activity results to display