${if(SFJM='全量',"
select * from View_ZJGD_GXBZ_ONLY where cast([boss归档时间] as date)>='"+time+"' and cast([boss归档时间] as date)<='"+time_c+"' and [是否是校园宽带] like '%否%'",
"select a.* from View_ZJGD_GXBZ_ONLY as a left join (select 工单编码 from ZJJM where cast(减免时间 as date) like '"+left(time,7)+"%') as b on a.工单编码=b.工单编码
where b.工单编码 is null and cast([boss归档时间] as date)>='"+time+"' and cast([boss归档时间] as date)<='"+time_c+"' and [是否是校园宽带] like '%否%'"
)}