select his_syxh,bahm,cyrq,cyks,zyzd,zyzdmc,zyssdm,zyssmc,lyfs,zyys,sfzh,'月' as tjlb

into #1

from SJCK_SYJBK (nolock)

where substring(cyrq,1,7)='${tjrq}'+'-'+'${tjsj}'

order by cyrq

union

select his_syxh,bahm,cyrq,cyks,zyzd,zyzdmc,zyssdm,zyssmc,lyfs,zyys,sfzh,'季' as tjlb

from 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 cyrq

union

select his_syxh,bahm,cyrq,cyks,zyzd,zyzdmc,zyssdm,zyssmc,lyfs,zyys,sfzh,'年' as tjlb

from SJCK_SYJBK (nolock)

where substring(cyrq,1,4) ='${tjrq}'

order by cyrq

select * from #1 (nolock)

where tjlb='${tjlb}'