Qurey problem

  • 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

  • mcbtiger420 (4/26/2010)


    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

    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