select a.lp_name,count(b.number) as number,sum(b.czdate) as czdate,sum(b.rate) as rate into #q1
from cdlp_hospital a left join cdlp_data b on a.lp_name=b.hospital
where b.outdate between 20060301 and 20030331
group by a.lp_nameselect lp_name,number,czdate,(czdate/number) as tianshu,rate,(rate/number) as jine,(rate/number/czdate) as mrp from #q1
from cdlp_hospital a left join cdlp_data b on a.lp_name=b.hospital
where b.outdate between 20060301 and 20030331
group by a.lp_nameselect lp_name,number,czdate,(czdate/number) as tianshu,rate,(rate/number) as jine,(rate/number/czdate) as mrp from #q1
解决方案 »
- 不同存储过程中的本地临时表名一样
- 如何从多个表查询出来数据满足后面条件的才显示出来。
- sql2005根据某个字符筛选表
- 某些sql执行后,在消息中,会发现有worktable,I/O很大,解释此现象
- 由于数据移动,未能继续以nolock方式扫描
- SQL server安装的系统要求是什么?XP可以吗?
- 日期分隔...
- 关于表的关系的问题!!!!
- 在存储过程中如何判断语句是否正常执行?
- 再次请教高手,这个连接怎么写
- 一个触发器的问题
- 请问这个 SQL 语句 如何 写??????????????????????? 急!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
select a.lp_name,count(b.number) as number,sum(b.czdate) as czdate,sum(b.rate) as rate
from cdlp_hospital a left join cdlp_data b on a.lp_name=b.hospital
where b.outdate between 20060301 and 20030331
group by a.lp_name)
union
select lp_name,number,czdate,(czdate/number) as tianshu,rate,(rate/number) as jine,(rate/number/czdate) as mrp from #q1
from (select a.lp_name,count(b.number) as number,sum(b.czdate) as czdate,sum(b.rate) as rate
from cdlp_hospital a left join cdlp_data b on a.lp_name=b.hospital
where b.outdate between 20060301 and 20030331
group by a.lp_name
) as a