I have 1 Question
- When I use where date condition it error " Unknow Column %0 " but if i use another Column example DocNum It not error
My Query below
SELECT
T10.[firstName],
T11.[U_NAME],
T0.[CardName],
T1.[ItemCode],
T1.[Dscription],
T1.[Quantity],
T1.[Price],
T1.[LineTotal],
T8.[TaxDate],
T0.[U_DatePOtoSup],
T0.[U_DeleveryDate],
T3.[U_DateRecSup],
T3.[U_DateQCRec],
T5.[TaxDate],
T8.[DocEntry],
T6.[DocNum],
T0.[DocNum],
T0.[TaxDate],
T5.[DocNum],
T5.[NumAtCard],
T1.[LineStatus]
FROM
OPOR T0
INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry]
LEFT JOIN [dbo].[@PURCHASEHEADER] T2 ON T0.[Docnum] = T2.[U_PONo]
LEFT JOIN [dbo].[@PURCHASEDETAIL] T3 ON T2.[DocEntry] = T3.[DocEntry]
AND T1.[Itemcode] = T3.[U_Itemcode]
AND (T1.LineNum + 1) = T3.U_LineNo
LEFT JOIN PDN1 T4 ON T0.[DocNum] = T4.[BaseRef]
AND T1.[ItemCode] = T4.[ItemCode]
LEFT JOIN OPDN T5 ON T4.[DocEntry] = T5.[DocEntry]
LEFT JOIN OPRQ T6 ON T1.[BaseRef] = T6.[DocNum]
LEFT JOIN PRQ1 T7 ON T6.[DocEntry] = T7.[DocEntry]
AND T1.[ItemCode] = T7.[ItemCode]
LEFT JOIN ODRF T8 ON T6.[draftKey] = T8.[DocEntry]
LEFT JOIN DRF1 T9 ON T8.[DocEntry] = T9.[DocEntry]
AND T1.[ItemCode] = T9.[ItemCode]
LEFT JOIN OHEM T10 ON T8.[OwnerCode] = T10.[empID]
LEFT JOIN OUSR T11 ON T0.[UserSign] = T11.[USERID]
WHERE T0.[DocDate] >= [%0] AND T0.[DocDate] <= [%1]