select his_syxh,bahm,cyrq,cyks,zyzd,zyzdmc,zyssdm,zyssmc,lyfs,zyys,sfzh,'月' as tjlbinto #1from SJCK_SYJBK (nolock)where substring(cyrq,1,7)='${tjrq}'+'-'+'${tjsj}'order by cyrqunionselect his_syxh,bahm,cyrq,cyks,zyzd,zyzdmc,zyssdm,zyssmc,lyfs,zyys,sfzh,'季' as tjlbfrom SJCK_SYJBK (nolock)where case when substring(cyrq,6,2) in ('01','02','03') then substring(cyrq,1,4)+'一季度' when substring(cyrq,6,2) in ('04','05','06') then substring(cyrq,1,4)+'二季度' when substring(cyrq,6,2) in ('07','08','09') then substring(cyrq,1,4)+'三季度' when substring(cyrq,6,2) in ('10','11','12') then substring(cyrq,1,4)+'四季度' end ='${tjrq}'+'${tjsj}'order by cyrqunionselect his_syxh,bahm,cyrq,cyks,zyzd,zyzdmc,zyssdm,zyssmc,lyfs,zyys,sfzh,'年' as tjlbfrom SJCK_SYJBK (nolock)where substring(cyrq,1,4) ='${tjrq}'order by cyrqselect * from #1 (nolock)where tjlb='${tjlb}'