Declare @tablename varchar(30)
Declare @tabletmp varchar(10)
set @tablename=''
select top 3 @tablename=@tablename+name +',' from sysobjects where xtype='U' and name like 'table%' and datediff(day,crdate,getdate())<=3 order by crdate
while @tablename<>''
begin
set @tabletmp=left (@tablename,charindex(',',@tablename)-1)
set @tablename=right(@tablename,len(@tablename)-len(@tabletmp)-1)
Exec ('Select * From ' +@tabletmp)
end
Declare @tablename varchar(30)
Declare @tabletmp varchar(10)
set @tablename=''
select top 3 @tablename=@tablename+name +',' from sysobjects where xtype='U' and datediff(day,crdate,getdate())<=3 order by crdate
while @tablename<>''
begin
set @tabletmp=left (@tablename,charindex(',',@tablename)-1)
set @tablename=right(@tablename,len(@tablename)-len(@tabletmp)-1)
Exec ('Select * From ' +@tabletmp)
end