You've to build and run dynamic sql using EXECUTE command or sp_executesql system sproc.

Declare @Myparam as Varchar(50), @SqlStr varchar (512)

Set @MyParam = 'TableName'

SET @SqlStr = 'Select * from A_Table as T1 Left join ' + ;
		@MyParam + ' as T2 on T2.Id=T1.Id'

EXECUTE (@SqlStr)

>How can I pass a table name as a parameter in SQL Server 2000 stored procedure?
>
>For exemple:
>

>Declare @Myparam as Varchar(50)
>
>Set @MyParam = 'TableName'
>
>Select * from A_Table as T1
>Left join @MyParam as T2 on T2.Id=T1.Id
>

>
>This sample does not work, but It represent what I'd like to do
>
>Thanks