Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Question on PIVOT

    I was using the incorrect Column for the PIVOT assignment...

    SELECT ACCOUNTNUM, [0] AS DEBIT_TRANS, [1] AS CREDIT_TRANS
    FROM
    (
        SELECT ACCOUNTNUM, CREDITING, AMOUNTMST
        from [dbo].[LEDGERTRANS]
        where...

Viewing post 1 (of 1 total)