1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| /****** Script de la commande SelectTopNRows à partir de SSMS ******/
SELECT OrderArticleLines.OrderNumber AS REFERENCE, OrderArticleLines.Description, StockItems.NumInStock AS STOCK,
BPLASTNET.dbo.F_Get_ENCDE(OrderArticleLines.OrderNumber) AS 'EN CDE', BPLASTNET.dbo.F_GetQuantite_Reservation(OrderArticleLines.OrderNumber)
AS RESERVE, OrderArticleLines.Amount AS 'A CDER', + CAST('X ' AS varchar) + CAST(CONVERT(decimal, OrderArticleLines.PackQuantity, 0) AS varchar) AS UDC,
OrderArticleLines.Location, '' AS [QTE SOUHAITE]
FROM Orders INNER JOIN
OrderArticleLines ON Orders.Identifier = OrderArticleLines.[Order] LEFT OUTER JOIN
LinkColorsFinishGroups ON OrderArticleLines.LinkColorFinishGroupIn = LinkColorsFinishGroups.Identifier LEFT OUTER JOIN
StockOptions INNER JOIN
StockItems ON StockOptions.Identifier = StockItems.StockOption ON OrderArticleLines.OrderNumber = StockItems.OrderCode LEFT OUTER JOIN
Colors ON LinkColorsFinishGroups.ColorId = Colors.Identifier
WHERE (Orders.Identifier =
(SELECT MAX(Identifier) AS Expr1
FROM Orders AS Orders_1
WHERE (Description = 'SOMFY')))
GROUP BY OrderArticleLines.OrderNumber, OrderArticleLines.Description, StockItems.NumInStock, BPLASTNET.dbo.F_Get_ENCDE(OrderArticleLines.OrderNumber), OrderArticleLines.PackQuantity,
BPLASTNET.dbo.F_GetQuantite_Reservation(OrderArticleLines.OrderNumber), OrderArticleLines.Amount, + CAST('X ' AS varchar) + CAST(CONVERT(decimal,
OrderArticleLines.PackQuantity, 0) AS varchar), OrderArticleLines.Location
HAVING (StockItems.NumInStock + OrderArticleLines.Amount * OrderArticleLines.PackQuantity - BPLASTNET.dbo.F_GetQuantite_Reservation(OrderArticleLines.OrderNumber)
>= 0)
ORDER BY REFERENCE |
Partager