let a inputvariable deside which table is queried...

[ruupy]

Hello,
A short SP problem this time.
What do you do when you want the table on which the query is run, to be dependant on an SP-input-variable?

an SP-user executes the SP in the following way :
**************
exec sp_test @whichtable = 'table_01'
**************


As part of the SP, the following...
**************
....
select * from @whichtable
...
**************
........is not accepted.

Does anybody have a slik idea /workaround?????


ThenX
RuupY

 

[ColinM]

You have to use "dynamic SQL".

declare @sql varchar(1000)
set @sql = "select * from " + @whichtable
exec (@sql)

 

[ruupy]

ThenX a lot.

Short
Sweet
'n
Simple

...worx like charm!