Error - Invalid Number when i use String_Agg

• jagjitsingh

  Ten Centuries

  Points: 1072

  More actions

  April 16, 2025 at 2:12 pm

  #4579967

  Hi

  Select T1."transType",

  WHEN T1."TransType" = '46' THEN (SELECT STRING_AGG (A0."LocCode", ',') from PCH1 A0 inner join OPCH A1 on A0."DocEntry" = A1."DocEntry" and A1."BPLId" = T1."BPLId" inner join VPM2 A2 on A2."DocNum" = T1."CreatedBy" and A0."DocEntry" = A2."DocEntry")

  from JDT1 T1

  Thanks

   

• Site Owners

  SSC Guru

  Points: 80382

  More actions

  April 17, 2025 at 3:10 pm

  #4580540

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.