select @sql=isnull(@sql+'+','')+'(case when exists(select 1 from tb where '+name+' is null) then 0 else 1 end)'
from sys.syscolumns
where id =OBJECT_ID('RPT_resultA4……
[/Quote]
select @sql=isnull(@sql+'+','')+'(case when exists(select 1 from tb where '+name+' is null) then 0 else 1 end)'
from sys.syscolumns
where id =OBJECT_ID('RPT_resultA41……
[/Quote]
这个数要作为被除数的,这样子行吗
select @sql=isnull(@sql+'+','')+'(case when exists(select 1 from tb where '+name+' is null) then 0 else 1 end)'
from sys.syscolumns
where id =OBJECT_ID('RPT_resultA41……
[/Quote]
Josy,可以了!谢谢啦!
select @sql=isnull(@sql+'+','')+'(case when exists(select 1 from tb where '+name+' is null) then 0 else 1 end)'
from sys.syscolumns
where id =OBJECT_ID('RPT_resultA41') and name like 'Mtd201%'
select @sql=isnull(@sql+'+','')+'(case when exists(select 1 from tb where '+name+' is null) then 0 else 1 end)'
from sys.syscolumns
where id =OBJECT_ID('RPT_resultA41……
[/Quote]