declare @q varchar(10)
set @q=(select substring(convert(varchar(10),getdate(),112),1,6)-1)
exec ('select * from ['+@q+'] ')
declare @q varchar(10)
set @q=(select substring(convert(varchar(10),getdate(),112),1,6)-1)
exec ('select * from ['+@q+'] ')