Forum Replies Created

Viewing 2 posts - 31 through 32 (of 32 total)

  • RE: CTE Recursive Query

    I have tried to follow the guide as per the response from Sue and Jeff.

    Can someone please advise I have have done this incorrectly so that I can...

    February 15, 2017 at 10:26 am

    #1928674

  • RE: CTE Recursive Query

    Here is an example data set:

    ParentWO
    2088/1.1    		IssueQty
    14    		ChildWO
    2088/1.1.1    		Production_Qty
    40    		Qty_Complete
    40
    2088/1.1252088/1.1.14040
    2088/1.112088/1.1.24040
    2088/1.1142088/1.1.24040
    2088/1.1.1402088/1.1.1.14040
    2088/1.1.2402088/1.1.2.14040

    I have rewritten the CTE query as follows:
    WITH mlBOM AS (SELECT  ...

    February 9, 2017 at 1:34 am

    #1927457

Viewing 2 posts - 31 through 32 (of 32 total)