CODEWITHSUNDEEP
sql-servert-sql
stanke
stanke

Reputation: 286

How to create view that pulls data from different table each month

I have new table each month that is basically the same only it contains data for that month. For example

Table_201510 -- for October
Table_201511 -- for November and so on...

I want to create a view that will give me the possibility to get data for current month in uniform way. For example:

select * from vwTable_CurrentMonth

Is there a way of doing this without sp_executesql , like maybe creating an alias or something?

Upvotes: 0

Views: 45

Answers (1)

paparazzo
paparazzo

Reputation: 45096

Have a view vwTable_CurrentMonth that you modify each time you create a new table to select from that new table.

Upvotes: 1

Related Questions