28,391
社区成员
发帖
与我相关
我的任务
分享帮忙写个SQL自定义函数
传入 contractid 为int 类型，返回numeric类型
select Sum(BF.FeeRate) from BudgetFees BF
LEFT JOIN ChargeSub cs ON BF.ChargeId = cs.ChargeCode
where cs.FeeRateUnit ='%'
and bf.Oversea = 1 and bf.Contractid =
select Sum(BF.FeeRate) from BudgetFees BF
LEFT JOIN ChargeSub cs ON BF.ChargeId = cs.ChargeCode
where cs.FeeRateUnit ='%'
and bf.Oversea = 1 and bf.Contractid =
...全文
请发表友善的回复…
发表回复
kmiaoer 2008-11-21
- 打赏
- 举报
自己搞定。。
kmiaoer 2008-11-21
- 打赏
- 举报
up
kmiaoer 2008-11-21
- 打赏
- 举报
再此上下文中不能使用带有返回值的return
草原可可 2008-11-21
- 打赏
- 举报
报什么错误 错误代码
kmiaoer 2008-11-21
- 打赏
- 举报
CREATE FUNCTION Fee_No_BFB(@ContractID as int)
return numeric
as
begin
declare @i numeric
select @i=Sum(BF.FeeRate) from BudgetFees BF LEFT JOIN ChargeSub cs ON BF.ChargeId = cs.ChargeCode where cs.FeeRateUnit ='%' and bf.Oversea = 1 and bf.Contractid = @ContractID
return @i
end
我写的这个老是出错。。请大哥看看
return numeric
as
begin
declare @i numeric
select @i=Sum(BF.FeeRate) from BudgetFees BF LEFT JOIN ChargeSub cs ON BF.ChargeId = cs.ChargeCode where cs.FeeRateUnit ='%' and bf.Oversea = 1 and bf.Contractid = @ContractID
return @i
end
我写的这个老是出错。。请大哥看看
