2
Answers

Incorrect Syntax near SqlQuery

Ramco Ramco

Ramco Ramco

4d
48
1

Hi

 In below code i am getting error "Incorrect Syntax near SqlQuery

DECLARE ColumnNames nvarchar(100);
Declare SQLQuery nvarchar(100);

SELECT STRING_AGG("U_A_M", ', ')  
FROM (SELECT DISTINCT (T2."U_A_M")
            FROM Oitm T2) As cols;

SET SQLQuery =  'SELECT itemcode, ' + cols + ' from
            (
                SELECT T1."ItemCode",T1."LineTotal", T2."U_A_M"
    FROM Opch T0 inner join Pch1 T1 on T0."Docentry" = T1."DocEntry"
	inner join Oitm T2 on T1."ItemCode" = T2."ItemCode"
	where T2.U_A_M <> ''NA''
           ) x
            pivot
            (
                 sum(linetotal)
                for U_A_M in (' + cols + ')
            ) p '


execute(SQLQuery)

Thanks

Answers (2)