Viewing post 1 (of 1 total)
I was using the incorrect Column for the PIVOT assignment...
SELECT ACCOUNTNUM, [0] AS DEBIT_TRANS, [1] AS CREDIT_TRANSFROM ( SELECT ACCOUNTNUM, CREDITING, AMOUNTMST from [dbo].[LEDGERTRANS] where...
April 14, 2018 at 11:23 am
#1986853