select isnull(sum(sl),0) as sl,isnull(sum(dkje),0) as dkje,isnull(sum(gcts),0) as gcts,hzjxsdm from
(select isnull(count(hth),0) as sl,isnull(sum(-dkje),0) as dkje,isnull(sum(-gcts),0) as gcts,hzjxsdm from ht where yxbz='0' and convert(char(6),isnull(hzqxrq,''),112)='200708' group by hzjxsdm
union all
select isnull(count(hth),0) as sl,isnull(sum(bgdkje),0) as dkje,isnull(sum(bgts),0) as gcts,jxsdm as hzjxsdm from htbgb where convert(char(6),isnull(bgsj,''),112)='200708' group by jxsdm) a
group by hzjxsdm 怎么样优化这个查询。。把 union all去掉!!只要一个查询语句
(select isnull(count(hth),0) as sl,isnull(sum(-dkje),0) as dkje,isnull(sum(-gcts),0) as gcts,hzjxsdm from ht where yxbz='0' and convert(char(6),isnull(hzqxrq,''),112)='200708' group by hzjxsdm
union all
select isnull(count(hth),0) as sl,isnull(sum(bgdkje),0) as dkje,isnull(sum(bgts),0) as gcts,jxsdm as hzjxsdm from htbgb where convert(char(6),isnull(bgsj,''),112)='200708' group by jxsdm) a
group by hzjxsdm 怎么样优化这个查询。。把 union all去掉!!只要一个查询语句
解决方案 »
- dts包失败问题
- 显示一个表的所有字段,
- 高分请教高手:win server 2003企业版 sp2 安装sql server 2008企业版问题
- 按月汇总,月份做列名,该如何写?
- sqlserver安装出现问题,报错很奇怪!在这里,没有搜到相同的报错信息!!!谢谢!!
- 关于SQL数据库的数据导入到ORACLE数据库里的问题
- sql 没有颜色
- 在SQL中的Diagrams 是怎么用的!在实际程序应用中有什么作用?
- 请问一下:如何把整数日期转化为标准日期?
- 对两个表A,B中字段不同项的SQL命令是什么?
- 查询两个表,有筛选条件只能查出筛选条件的数据,如何得到其中一个表的所有数据
- 如何把Tab键过滤掉
(select isnull(count(hth),0) as sl,isnull(sum(-dkje),0) as dkje,isnull(sum(-gcts),0) as gcts,hzjxsdm from ht where yxbz='0' and convert(char(6),isnull(hzqxrq,''),112)='200708' group by hzjxsdm
union all select isnull(count(hth),0) as sl,isnull(sum(bgdkje),0) as dkje,isnull(sum(bgts),0) as gcts,jxsdm as hzjxsdm from htbgb where convert(char(6),isnull(bgsj,''),112)='200708' group by jxsdm) a group by hzjxsdm
(
select isnull(count(hth),0) as sl,isnull(sum(-dkje),0) as dkje,isnull(sum(-gcts),0) as gcts,hzjxsdm from ht where yxbz='0' and convert(char(6),isnull(hzqxrq,''),112)='200708' group by hzjxsdm
union all select isnull(count(hth),0) as sl,isnull(sum(bgdkje),0) as dkje,isnull(sum(bgts),0) as gcts,jxsdm as hzjxsdm from htbgb where convert(char(6),isnull(bgsj,''),112)='200708' group by jxsdm
) a
group by hzjxsdm
如果把存储过程ALTER一下.第一次运行系统又是好的..以后又出现上面的提示
!
是什么原因啊!