JoshZastrow/Total_due_this_year

Created March 21, 2017 12:41

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/JoshZastrow/d03dc78db3d5a0d269b1052a2dae917d.js"></script>
Save JoshZastrow/d03dc78db3d5a0d269b1052a2dae917d to your computer and use it in GitHub Desktop.

Download ZIP

ERP Production Parts, Year's orders less than a bars quantity of parts

Raw

Total_due_this_year

	SELECT
	OrderRel.PartNum,
	Sum(OrderRel.OurReqQty) AS 'Required for 2017'
	FROM ERP10PROD.Erp.OrderRel OrderRel
	WHERE (OrderRel.ReqDate<'20171231')
	GROUP BY OrderRel.PartNum

Author

JoshZastrow commented Mar 21, 2017

Returns a list of part numbers with the total number of parts due until the end of the year

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment