两个SQL union all 拼接一下，之后where条件分别if判断一下两个日期时间段里是否包含今天，分别过滤就行了

SQLserver 为例：

WHERe 1=1 

${IF(STR_DATE <= TODAY() && END_DATE >= TODAY(),"AND INSPECTION_DATE >='"+STR_DATE+"'","AND INSPECTION_DATE >='"+STR_DATE+"'")}

${IF(STR_DATE <= TODAY() && END_DATE >= TODAY(),"AND INSPECTION_DATE <=getdate()","AND INSPECTION_DATE >='"+END_DATE+"'")}

第二个

WHERe 1=1 

${IF(STR_DATE <= TODAY() && END_DATE >= TODAY(),"AND INSPECTION_DATE >=getdate()","AND INSPECTION_DATE >='"+STR_DATE+"'")}

${IF(STR_DATE <= TODAY() && END_DATE >= TODAY(),"AND INSPECTION_DATE <='"+END_DATE+"'","AND INSPECTION_DATE <='"+END_DATE+"'")}

${if(rq<today(),"sq1","sq2")}

直接在数据集里面判断

${if(rq<today(),"/*","")}

SQL1部分

${if(rq<today(),"*/","")}

${if(rq>=today(),"/*","")}

SQL2部分

${if(rq>=today(),"*/","")}