Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: select statement....inventory break down.

    Hi Lowell,

    base on you suggestion this is what I came up with from the data posted...

    SELECT

    A.acct,

    SUM(A.qty_buy) buy,

    SUM(A.qty_sell) sell,

    (SUM(A.qty_buy) - SUM(A.qty_sell)) stock,

    MAX(A.[date]) tran_date

    FROM

    (

    SELECT ACCT, qty qty_buy, 0 qty_sell, [date]

    FROM #tmpInvTbl...

  • RE: select statement....inventory break down.

    Hi,

    Did you come up with a solution? I have a very similar problem, and like to see how you solved it.

    thanks

Viewing 2 posts - 1 through 2 (of 2 total)