CREATE PROCEDURE yzcx_se_zydcf
@ksrq varchar(8),
@jsrq varchar(8),
@cfje numeric(18,2)
ASselect * into #temp1 from
(select a.cfbh,b.brxm,c.czyxm,a.fyje,a.sfrq,e.fymc
from zysf_cyfymx a,zysf_cydj b,sys_czydm c,sys_kssz d,sys_fyxm e
where cfbh is not null
and a.zydj_id=b.zydj_id
and a.kdys=c.czydm
and a.kd_ksdm=d.ksdm
and a.fydm=e.fydm
and (convert(char,a.sfrq,112)>=@ksrq and
convert(char,a.sfrq,112)<=@jsrq) and
a.fyje>=@cfje union all select a.cfbh,b.brxm,c.czyxm,a.fyje,a.sfrq,e.fymc
from zysf_zyfymx a,zysf_zydj b,sys_czydm c,sys_kssz d,sys_fyxm e
where cfbh is not null
and a.zydj_id=b.zydj_id
and a.kdys=c.czydm
and a.kd_ksdm=d.ksdm
and a.fydm=e.fydm
and (convert(char,a.sfrq,112)>=@ksrq and
convert(char,a.sfrq,112)<=@jsrq) and
a.fyje>=@cfje) kselect * from #temp1
GO
@ksrq varchar(8),
@jsrq varchar(8),
@cfje numeric(18,2)
ASselect * into #temp1 from
(select a.cfbh,b.brxm,c.czyxm,a.fyje,a.sfrq,e.fymc
from zysf_cyfymx a,zysf_cydj b,sys_czydm c,sys_kssz d,sys_fyxm e
where cfbh is not null
and a.zydj_id=b.zydj_id
and a.kdys=c.czydm
and a.kd_ksdm=d.ksdm
and a.fydm=e.fydm
and (convert(char,a.sfrq,112)>=@ksrq and
convert(char,a.sfrq,112)<=@jsrq) and
a.fyje>=@cfje union all select a.cfbh,b.brxm,c.czyxm,a.fyje,a.sfrq,e.fymc
from zysf_zyfymx a,zysf_zydj b,sys_czydm c,sys_kssz d,sys_fyxm e
where cfbh is not null
and a.zydj_id=b.zydj_id
and a.kdys=c.czydm
and a.kd_ksdm=d.ksdm
and a.fydm=e.fydm
and (convert(char,a.sfrq,112)>=@ksrq and
convert(char,a.sfrq,112)<=@jsrq) and
a.fyje>=@cfje) kselect * from #temp1
GO
解决方案 »
- 在SQL中分类汇总的问题
- 使用exec创建动态查询如何得到查询返回的字段?返回值要赋给存储过程中的变量,不是返回给应用程序。急!!
- 超难问题!!!! 如何用 t-sql 语句 获得 有 多少个 客户端 连接 数据库 !!!!!!!!!!!!!
- SQLWB - SQL Server Management Studio 遇到问题需要关闭。
- 救命啊,不小心将mssql的的数据库“生成数据库脚本”又执行了一次,导致数据库的数据丢失,怎么恢复啊
- mysql计算时间的timestamp 在sqlserver里用什么函数?
- 关于邹建的贴子
- 求一段sql判断当前日期在往月(已经过了的月份);
- 全文检索问题--高分求教
- 存储过程的困惑---如何输入变量字段
- 能不能定义清楚些说明:什么是数据库开发?
- 求1简单sSQL,对的立刻给分!
@ksrq varchar(8),
@jsrq varchar(8),
@cfje numeric(18,2)
ASselect * from into #temp1
(select a.cfbh,b.brxm,c.czyxm,a.fyje,a.sfrq,e.fymc
from zysf_cyfymx a,zysf_cydj b,sys_czydm c,sys_kssz d,sys_fyxm e
where cfbh is not null
and a.zydj_id=b.zydj_id
and a.kdys=c.czydm
and a.kd_ksdm=d.ksdm
and a.fydm=e.fydm
and (convert(char,a.sfrq,112)>=@ksrq and
convert(char,a.sfrq,112)<=@jsrq) and
a.fyje>=@cfje union all select a.cfbh,b.brxm,c.czyxm,a.fyje,a.sfrq,e.fymc
from zysf_zyfymx a,zysf_zydj b,sys_czydm c,sys_kssz d,sys_fyxm e
where cfbh is not null
and a.zydj_id=b.zydj_id
and a.kdys=c.czydm
and a.kd_ksdm=d.ksdm
and a.fydm=e.fydm
and (convert(char,a.sfrq,112)>=@ksrq and
convert(char,a.sfrq,112)<=@jsrq) and
a.fyje>=@cfje) kselect * from #temp1
GO
与
from zysf_zyfymx