Hi Ann

Didn't see it in my inbox so I guess nobody else have also received it, so
I am reposting. Forgive me if other have received it.

At 10:16 am 07/12/2004, Namit Nathwani wrote:

>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@...
>___________________________________________

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]