April 26, 2010 at 10:52 am
Hello Dear
My problem is writing Stock query problem i have project to create Stock Software my senireo is
I have five fields in sql server 2000
Dates Openstock ClientName Quantity EndStock
25/4/2010 100 Jack 50 50
26/4/2010 200+50 Micheal 130 120
my problem is i try to add 25/4/2010 (50)stock left to 26/4/2010 current day openstock new stock is 200 previous day Endstock
i want to result like that
Dates Openstock ClientName Quantity EndStock
25/4/2010 100 Jack 50 50
26/4/2010 250 Micheal 130 120
April 26, 2010 at 10:58 am
mcbtiger420 (4/26/2010)
Hello DearMy problem is writing Stock query problem i have project to create Stock Software my senireo is
I have five fields in sql server 2000
Dates Openstock ClientName Quantity EndStock
25/4/2010 100 Jack 50 50
26/4/2010 200+50 Micheal 130 120
my problem is i try to add 25/4/2010 (50)stock left to 26/4/2010 current day openstock new stock is 200 previous day Endstock
i want to result like that
Dates Openstock ClientName Quantity EndStock
25/4/2010 100 Jack 50 50
26/4/2010 250 Micheal 130 120
I'm confused. One, the two rows above don't appear to me to be related as the ClientName in each is different. My second issue is related to where the 50 came from, but looking at it with the columns properly aligned has helped. Quantity, apparently, is the amount deducted that day. What about when inventory is added, is that shown as a negative quantity?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy