Skip to Content
0
J S
Jul 29, 2020 at 06:34 AM

Query with Parameters

36 Views

Hi

I have below code and i want to add From Date & To Date parameter & also Warehouse Parameter

SELECT T0.DocNum, T0.DocType, T0.DocDate, T0.CardName, T0.DocTotal, T0.U_TranCat, T1.DocEntry, T1.Dscription, T1.Quantity, T1.Price
FROM dbo.OWTR T0 INNER JOIN dbo.WTR1 T1 ON T0.DocEntry = T1.DocEntry

Thanks