Re: inventory management problem
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Sun, 15 Oct 2006 14:35:42 GMT
Message-ID: <2HrYg.5761$cz.86850_at_ursa-nb00s0.nbnet.nb.ca>
Date: Sun, 15 Oct 2006 14:35:42 GMT
Message-ID: <2HrYg.5761$cz.86850_at_ursa-nb00s0.nbnet.nb.ca>
Volker Hetzer wrote:
> prabuinet schrieb:
>
>> I have two tables:
>>
>> purchase (ItemId, PurchQuantity, PurchaseDate);
>> sales (ItemId, SalesQuantity, SalesDate);
>>
>>
>> With these two table could I able to find:
>>
>> 1. Quantity in Stock at any given date of any item.
>> 2. Purchase and Sales and their OpeningStock and ClosingStock Report
>> Ordered by date
> > What are opening and closing stock reports? > And is this a homework assignment? You sure go about it like if it is.
Nah, he's just some guy in India who isn't really qualified to do your job, and wants you to do it for him so he can get paid instead of you. Received on Sun Oct 15 2006 - 16:35:42 CEST