Hi
SELECT T0.U_TDSCRDCD,T1.CardName, T0.U_TDSPSTDT 'DATE OF PAYMENT/CREDIT',T2.U_TDSCATDC FROM [dbo].[@CXS_TDS_ENTRY] T0 Inner Join Ocrd T1 on T1.CardCode = T0.U_TDSCRDCD Inner Join [@CXS_TDS_CTGRY] T2 on T0.U_TDSCATCD = T2.U_TDSCATCD WHERE T0.U_TDSTXNTY = 'API' and T0.[U_TDSPSTDT] >=[%0] and T0.[U_TDSPSTDT] <=[%1]
order by T0.U_TDSCATCD,T0.U_TDSPSTDT
I want Party Pan No in this
Thanks