quote:

---

while @tempDate <= @endDate
begin
begin

select @tempBal = value_date_bal
from dbo.SRC_EAB
where acid = @cAcid
and @tempDate >= COALESCE(eod_date, eod_date)
and end_eod_date >= @tempDate
OPTION (FORCE ORDER)

SELECT @SWV_no_data_err = @@ROWCOUNT

IF (@SWV_no_data_err = 0)
SET @tempBal = 0.00
end

if @tempBal <= 0.00
SET @debitBal = @debitBal+@tempBal
else
SET @creditBal = @creditBal+@tempBal


SET @tempDate = dateadd(day,1,@tempDate)
end

---

select	@debitBal	= sum(case when value_date_bal <= 0 then value_date_bal else 0 end),
	@creditBal	= sum(case when value_date_bal >  0 then value_date_bal else 0 end)
from 	dbo.SRC_EAB
where 	acid 		= @cAcid
and 	@tempDate 	>= COALESCE(eod_date, eod_date)
and 	end_eod_date 	>= @beginDate
and	end_eod_date	<= @endDate