I have to change the name of the history table dynamically to what is passed in the start date. If @start_date= '1/1/2014' then it should be history_jan14 If @start_date ='02/01/2014' then it should be history_feb14 and so on. Is there a way you can do it ? I am using SQL Server 2008.
I have to say...I'm not sure your database design is quite right. One table should hold all items. Having said that, you could use dynamic sql to query your different tables based on an input parameter.