I am trying to write a query to pull data from a table that is system generated daily at midnight. I tried:
declare @tablename varchar(50) set @tablename = (select name from sysobjects where crdate = '05/01/2003') select * from @tablename
But I get an error on 'select * from @tablename' (must declare @tablename)
Any assistance is GREATLY APPRECIATED!!!!