select substring(rq,1,4)+'-'+substring(rq,5,2)+'-'+substring(rq,7,2) as rqrq,substring(rq,1,4)+'-'+substring(rq,5,2) as rqrq1,bqdm,zyrs,'月' as tjlbinto #1from CDR.CDR_JCYL.dbo.HIS_YZCX_YZRB_ZY a (nolock)where substring(rqrq1,1,7)='${tjrq}'+'-'+'${tjsj}'unionselect substring(rq,1,4)+'-'+substring(rq,5,2)+'-'+substring(rq,7,2) as rqrq,substring(rq,1,4)+'-'+substring(rq,5,2) as rqrq1,bqdm,zyrs,'季' as tjlbfrom CDR.CDR_JCYL.dbo.HIS_YZCX_YZRB_ZY a (nolock)where case when substring(rqrq1,6,2) in ('01','02','03') then substring(rqrq1,1,4)+'一季度' when substring(rqrq1,6,2) in ('04','05','06') then substring(rqrq1,1,4)+'二季度' when substring(rqrq1,6,2) in ('07','08','09') then substring(rqrq1,1,4)+'三季度' when substring(rqrq1,6,2) in ('10','11','12') then substring(rqrq1,1,4)+'四季度' end ='${tjrq}'+'${tjsj}'unionselect substring(rq,1,4)+'-'+substring(rq,5,2)+'-'+substring(rq,7,2) as rqrq,substring(rq,1,4)+'-'+substring(rq,5,2) as rqrq1,bqdm,zyrs,'年' as tjlbfrom CDR.CDR_JCYL.dbo.HIS_YZCX_YZRB_ZY a (nolock)where substring(rqrq1,1,4) ='${tjrq}'order by rqselect * from #1 (nolock)where tjlb='${tjlb}