Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  ?How to choose a table in SP/View w/ a variable

Author  Topic  dbleyl Starting Member 21 Posts Posted - 2001-03-30 : 10:11:48 Hi, OK, you can't use a variable for a table name in a FROM clause. Is there a way besides using a lot of IF's? The table choice is based on an int variable within a specific range, and there are *many* tables. I know this has to be a common question, but I searched the forum etc, and can't find what I'm looking for. Thanks, Don