I am trying to write a query to pull data from a table that is system generated daily at midnight. I tried:
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!!!!