Hi Ann

Thanks for your response.

At 09:51 pm 06/12/2004, you wrote:

>And if 165 had been 160.00, would the desired
>result have been
>
> >151 1 01/04/2004 0.00 0.00
> >165 2 05/04/2004 0.00 60.00
> >178 3 10/04/2004 250.00 0.00

Yes, then I would like to see the balance in the entry itself.

>What I'm trying to say is that creating a single SQL
>statement to handle logic as complex as this may be
>possible but it's not desireable. Use a stored procedure.

Could you kindly give me a small eg. for a stored procedure returning a value.

SELECT MyStoredProcDr(bDr, bCr) AS bBalDr, MyStoredProcCr(bDr, bCr) AS
bBalCr, ...

How would the store procedure work and return?


Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.806 / Virus Database: 548 - Release Date: 05/12/2004


[Non-text portions of this message have been removed]