How can I pass a table name to a stored procedure

[bigfoot]

I have a general procedure that i'd like to ass a table name to. It would kinda look like the following (6.5 & 7.0)<br>
<br>
CREATE PROCEDURE sp_mything (<br>
@tablename varchar(100)<br>
) as<br>
select * from @tablename where ....<br>
<br>
<br>
How can I get this to work????<br>
<br>

 

[SeanJansson]

<br>
Try using EXEC...<br>
<br>
declare @MyTable varchar (50)<br>
SELECT @MyTable = "sysObjects"<br>
<br>
EXEC ("SELECT * FROM " + @MyTable)<br>
<br>
Seán.<br>
<br>

 

[bigfoot]

WOW!!! Thanks so much! I've been looking for this for a while.