declare @Rate decimal(10,4),@MileageDate1 datetime,@MileageNo1 decimal(10,4),@InvoiceNo varchar(12),@TotalExpense int
declare expense_Cursor CURSOR for
select MileageDate,MileageNo from MileageChart where InvoiceNo = @InvoiceNo
order by MileageChartIDopen expense_Cursor
fetch expense_Cursor into @MileageDate1,@MileageNo1while @@FETCH_STATUS = 0
begin
execute wls_GetRateByDate @MileageDate1,@Rate
select @TotalExpense = @TotalExpense + (@MileageNo1*@Rate)
fetch expense_Cursor into @MileageDate1,@MileageNo1
endclose expense_Cursor
DEALLOCATE expense_Cursor
declare expense_Cursor CURSOR for
select MileageDate,MileageNo from MileageChart where InvoiceNo = @InvoiceNo
order by MileageChartIDopen expense_Cursor
fetch expense_Cursor into @MileageDate1,@MileageNo1while @@FETCH_STATUS = 0
begin
execute wls_GetRateByDate @MileageDate1,@Rate
select @TotalExpense = @TotalExpense + (@MileageNo1*@Rate)
fetch expense_Cursor into @MileageDate1,@MileageNo1
endclose expense_Cursor
DEALLOCATE expense_Cursor
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货