mayB2morrow
Programmer
Can anyone tell me why the following SQL statement doesn't work? I get an error telling me I must declare "@TableSelect".
And can anyone tell me how to change this code so that it does work?!
-------------------------------
Declare @adminuser varchar(20)
Set @adminuser = 'admin'
Declare @TableSelect varchar(200)
Set @TableSelect = @adminuser + '.Customers'
select * from @TableSelect
--------------------------------
Thanks!
Phil Marsay
And can anyone tell me how to change this code so that it does work?!
-------------------------------
Declare @adminuser varchar(20)
Set @adminuser = 'admin'
Declare @TableSelect varchar(200)
Set @TableSelect = @adminuser + '.Customers'
select * from @TableSelect
--------------------------------
Thanks!
Phil Marsay