I am needing a SQL expert to help me with a few query views. An ideal candidate will have worked on several SQL projects for mid to large scale projects. Microsoft Azure knowledge a plus.
Upon completion of a test query, you will have the potential of working with us in the future on an 'as needed' basis.
Please take a look at the attached image file. Your test will be to build a query that calculates the appropriate Projected_Ending_Inventory as stated on the image. The equation is as follows: For the first instance of a part number under a you will simply subtract the On_hand - Quantity. For all other instances you will subtract the previous instances Projected_Ending_Inventory by the current instance Quantity. IE. for line 2 you will do (169-4000). Appropriate values are stated on the image file.
Serious inquires only, if you are able to complete the test please contact me.