Using Variable in the FROM Clause 1

[Andel]

Is there anyone who can tell me how to use variable in the FROM clause? Ex.

declare @tblname varchar(50)
set @tblname = mytable
select * from @tblname

The myTable has some records but this query doesn't give any result. Can somebody tell me the trick? Thanks!

 

[jballum]

You have to build the string and then run it using exec (ie. dynamically).

select @dynamicQuery = 'select * from ' + @tblname
exec @dynamicQuery

Give this a shot.

JB

 

[Andel]

JB, it works... Thank you!

Maingel