Recursion Queries with a stored procedure?

• JackLeach1

  SSC Enthusiast

  Points: 187

  More actions

  September 11, 2021 at 4:31 pm

  #3928819

  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.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  September 12, 2021 at 5:10 pm

  #3928921

  Thanks for posting your issue and hopefully someone will answer soon.

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

• Jeff Moden

  SSC Guru

  Points: 1004593

  More actions

  September 12, 2021 at 6:04 pm

  #3928928

  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)