declare @sql varchar(8000)
set @sql=''
select @sql=@sql+'select '''+Domain+''','''+cast(id as varchar)+''', count(记录个数) from '
+Domain+'_'+cast(id as varchar)+'where datediff(dd,最新一天,getdate())=0 union all'
from A表
set @sql=left(@sql,len(@sql)-len(' union all'))
print @sql
exec(@sql)
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+'update set NewPost=( select count(记录个数) from '
+Domain+'_'+cast(id as varchar)+'where datediff(dd,最新一天,getdate())=0) where ID='''cast(id as varchar)+'''and Domain='''+ Domain+''' '
from A表
print @sql
exec(@sql)