on 06-04-2019 5:12 AM
SELECT *
FROM (SELECT b.ItemCode,c.ItemName,c.U_Size, c.U_Mode,d.ItmsGrpNam,c.U_SubGrp7,
DATENAME(MONTH, a.DocDate) [Month],
SUM(isnull(b.Quantity,0))[sales count]
FROM oinv a
left join INV1 b on a.DocEntry=b.DocEntry
left join OITM c on b.ItemCode=c.ItemCode
left join OITB d on c.ItmsGrpCod=d.ItmsGrpCod
LEFT JOIN NNM1 E ON A.Series=E.Series
where E.SeriesName LIKE 'MR%' AND A.CANCELED='N' AND B.WhsCode='SG' AND B.TreeType<>'I' AND A.PIndicator='FY1819' ---- Here how to pass runtime parameter in query manager
Hi,
You can use the syntax for parameters in complicated queries:
/* select * from OITM x */
DECLARE @Pindicator AS NVARCHAR(10)
SET @Pindicator = /* x.PIndicator */ '[%0]'
SELECT *
FROM (SELECT b.ItemCode,c.ItemName,c.U_Size, c.U_Mode,d.ItmsGrpNam,c.U_SubGrp7,
DATENAME(MONTH, a.DocDate) [Month],
SUM(isnull(b.Quantity,0))[sales count]
FROM oinv a
left join INV1 b on a.DocEntry=b.DocEntry
left join OITM c on b.ItemCode=c.ItemCode
left join OITB d on c.ItmsGrpCod=d.ItmsGrpCod
LEFT JOIN NNM1 E ON A.Series=E.Series
where E.SeriesName LIKE 'MR%' AND A.CANCELED='N' AND B.WhsCode='SG' AND B.TreeType<>'I' AND A.PIndicator=@Pindicator
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.