Recursion Queries with a stored procedure?

  • Do you have a way to use a recurser query with a stored procedure i have run into an issue to make a recurser query to show what products were consumed in a work order I need to be able to have the user enter the work order number and LOT and Sublot? then that info is fed into the recurser query. is that something that is possible in SQL?

    https://snaptube.cam/

    • This topic was modified 3 years, 9 months ago by JackLeach1.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • The answer to your question is most likely "YES" but you've not provided enough information to go any further than that.  Please see the first link in my signature line below for one way to get the best help from any SQL Server forum.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply