Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: thenaturalselector
- Order by date
-
Creating a variable to use as a table identifier
yah, i agree with you george, it would make my life easier. i cant change the way these tables are created but i do have the ability to create new tables within a different database. perhaps i should just create a table that aggregates these monthly tables and use that in my procedure?- thenaturalselector
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Creating a variable to use as a table identifier
Hey All, So i am writing a procedure and many of the tables i need to reference end with a date or interger, for example: dbo.activity_equation_201106 I am wondering if there is a way to replace the '201106' on the end of the table name with a variable so that i can easily change all tables...- thenaturalselector
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
