Incorrect Syntax

Oct 26 2023 5:14 AM

On below code i am getting error - The conversion of a varchar data type to a datetine data resulted in out-of-range value.

(SELECT PaymentDate = STUFF((
         SELECT ',' + A0.docdate from Orct A0 inner join Rct2 A1 on A1.Docnum = A0.docentry and A1.baseabs = T0.docentry
            FOR XML PATH('')
         ), 1, 1, ''))

Thanks

Answers (4)

Group By Row Number

select all with bit field