Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CONVERT(VARCHAR(10),FO.dateCreated, 101) AS date,
- SUM(FDL.quantity) AS quantity
- FROM FulfillmentDropshipLineitem FDL
- LEFT OUTER JOIN FulfillmentDropshipOrder FDO ON FDO.fulfillmentOrderID = FDL.fulfillmentOrderID
- LEFT OUTER JOIN FulfillmentOrder FO ON FO.fulfillmentOrderID = FDO.fulfillmentOrderID
- WHERE DateDiff(day, FO.dateCreated, getDate()) < 14
- GROUP BY CONVERT(VARCHAR(10), FO.dateCreated, 101)
- ORDER BY CONVERT(VARCHAR(10), FO.dateCreated, 101)
Add Comment
Please, Sign In to add comment