stored procedure using a dynamic table name

[bbolte]

i need to bring in the name of a temp table that is dynamically named. do i do that any different from a normal parameter?

 

[JamesLean]

You set up the parameter in the same way but you can't just substitute it into the FROM clause. You need to use dynamic SQL:

CREATE PROC myproc
  @tbl varchar(30)
AS

DECLARE @sql varchar(200)

SET @sql = 'SELECT col1, col2 FROM ' + @tbl

EXEC(@sql)
GO

--James

 

[bbolte]

thanks. just found the faq as well about this: faq183-3132. i probably should have done a search first. thanks again.