帆软用户A45YkexW7S(提问者) 我都加上了

回复

2024-01-04 10:05 

取消 回复

snrtuemc 回复 帆软用户A45YkexW7S(提问者) 似乎是还有其他的having函数上什么的，检查下，这个字段不要的话，在select时候去掉

回复

2024-01-04 10:09 

取消 回复

帆软用户A45YkexW7S(提问者) 回复 snrtuemc select *,\'月\' as tjlb1,count(distinct substring(dm,1,4)) as 数 into #sl from BK (nolock) where substring(cyrq,1,7)=\'${tjrq}\'+\'-\'+\'${tjsj}\' union select *,\'季\' as tjlb1,count(distinct substring(dm,1,4)) as 数 from BK (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}\' union select *,\'年\' as tjlb1,count(distinct substring(dm,1,4)) as 数 from BK (nolock) where substring(cyrq,1,4) =\'${tjrq}\' order by cyrq select * from #sl (nolock) where tjlb1=\'${tjlb}\'

回复

2024-01-04 10:24 

取消 回复

snrtuemc 回复 帆软用户A45YkexW7S(提问者) 额，你怎么有插入语句，还有临时表，这个在帆软数据集不支持，帆软数据集中只支持查询语句，调用存储过程语句，所以会报错的，建议做成存储过程，在帆软数据集直接调用存储过程

回复

2024-01-04 10:26 

取消 回复

帆软用户A45YkexW7S(提问者) 回复 snrtuemc 但是我其他的模板用临时表没事

回复

2024-01-04 10:38 

取消 回复

帆软用户A45YkexW7S(提问者) select *,\'月\' as tjlb1,count(distinct substring(dm,1,4)) as 数 into #sl from BK (nolock) where substring(cyrq,1,7)=\'${tjrq}\'+\'-\'+\'${tjsj}\' union select *,\'季\' as tjlb1,count(distinct substring(dm,1,4)) as 数 from BK (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}\' union select *,\'年\' as tjlb1,count(distinct substring(dm,1,4)) as 数 from BK (nolock) where substring(cyrq,1,4) =\'${tjrq}\' order by cyrq select * from #sl (nolock) where tjlb1=\'${tjlb}\'

回复

2024-01-04 10:23 

取消 回复

帆软用户A45YkexW7S(提问者) select *,\'月\' as tjlb1,count(distinct substring(dm,1,4)) as 数 into #sl from BK (nolock) where substring(cyrq,1,7)=\'${tjrq}\'+\'-\'+\'${tjsj}\' union select *,\'季\' as tjlb1,count(distinct substring(dm,1,4)) as 数 from BK (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}\' union select *,\'年\' as tjlb1,count(distinct substring(dm,1,4)) as 数 from BK (nolock) where substring(cyrq,1,4) =\'${tjrq}\' order by cyrq select * from #sl (nolock) where tjlb1=\'${tjlb}\'

回复

2024-01-04 10:24 

取消 回复

Gun鹏 回复 帆软用户A45YkexW7S(提问者) 有count 你得有group by分组

回复

2024-01-04 10:53 

取消 回复

帆软用户A45YkexW7S(提问者) 不太明白

回复

2024-01-04 10:56 

取消 回复

Gun鹏 回复 帆软用户A45YkexW7S(提问者) 比如:select a,b,count(c) from 表 group by a,b

回复

2024-01-04 11:00 

取消 回复