如何将多条记录存入一个临时表中,一起提交呢?这样才能做事务处理?帮忙给一段代码学习学习!!!!
解决方案 »
- (70分求解)想用DataView做一个多条件的查询,遇到点问题,请高手讲解一下
- 公司最近用asp.net做系统发布网站后,如何能应用到android,iphone等手机平台系统
- +++++++++++关于分页问题++++++++++++++
- 如何在.中调用jquery 代码呀,
- 关于弹出窗口的问题
- 刷新后页面定位的问题
- 水晶报表中,如何让一些内容只在第一页的顶端,另外一些内容只在最后一页的低端显示
- email服务器配置问题 紧急 大家帮忙 谢
- 能够自动生成xpath路径吗?
- 100分求<<用实例学ASP.NET>>配套光盘!
- 用file控件上传文件的安全性讨论,欢迎发表高见
- 如何取得当前日期!~然后在把日期加2个月 请高手指教 谢谢
跟Hashtable没有任何关系
@projectcode varchar(20)
as
select distinct a.projectCode,b.payModeCode,ratifyMoney=sum(b.ratifyMoney)
into #pt
from TP_ProjectMaster a inner join TP_ProjectDetail b on a.projectCode=b.projectCode
where a.ratifyStatusCode='3' and (a.executeStatusCode=0 or a.executeStatusCode=1)
group by b.payModeCode,a.projectCode
select distinct a.loanType,loanMoney=sum(b.loanMoney)
into #lt
from TL_LoanMaster a inner join TL_LoanMoneyDetail b on a.loanCode=b.loanCode
group by a.loanType select a.accountType,accountMoney=sum(b.accountMoney)
into #at
from TA_AccountMaster a inner join TA_AccountMoneyDetail b on a.accountCode=b.accountCode
group by a.accountType select a.projectCode,a.payModeCode,金额=a.ratifyMoney-b.loanMoney-c.accountMoney
into #t
from #pt a inner join #lt b on a.payModeCode=b.loanType inner join #at c on a.payModeCode=c.accountType
if @projectcode<>''
begin
select projectCode=max(a.projectCode),projectName=max(b.projectName)
,可借现金金额 =sum(case payModeCode when 2 then 金额 else 0 end)
,可借产品金额=sum(case payModeCode when 3 then 金额 else 0 end)
from #t a inner join TP_ProjectMaster b on a.projectCode=b.projectCode
where a.projectCode=@projectcode
end
if @projectcode=''
begin
select a.projectCode,b.projectName
,可借现金金额 =sum(case payModeCode when 2 then 金额 else 0 end)
,可借产品金额 =sum(case payModeCode when 3 then 金额 else 0 end)
from #t a inner join TP_ProjectMaster b on a.projectCode=b.projectCode
group by a.projectCode,b.projectName
order by a.projectCode,b.projectName
end drop table #pt,#lt,#at,#t
drop proc Test_GetAllCanLoanProjectexec Test_GetAllCanLoanProject 'P20040802001'exec Test_GetAllCanLoanProject ''
非常的好.记住了,该表必须要有主键才行.