Looping Challege

• calvin.clay

  SSC Rookie

  Points: 37

  More actions

  August 25, 2017 at 9:27 am

  #332310

  Hi,
  I have an interesting project.  I need to show materials that make up parts then find materials that make up those materials that they are composed of if any.  Not sure of what technique to get started with.  Any ideas?  Recursive?  Some kind of looping?  See the attachment of the result set I am looking for.

  Thanks,
  Calvin

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  August 25, 2017 at 10:17 am

  #1956888

  calvin.clay - Friday, August 25, 2017 9:27 AM

  Hi,
  I have an interesting project.  I need to show materials that make up parts then find materials that make up those materials that they are composed of if any.  Not sure of what technique to get started with.  Any ideas?  Recursive?  Some kind of looping?  See the attachment of the result set I am looking for.

  Thanks,
  Calvin

  It depends on the data structure that you have. If you still don't have the structure, I suggest that you read the following articles:
   http://www.sqlservercentral.com/articles/Hierarchy/94040/
   http://www.sqlservercentral.com/articles/T-SQL/94570/
  If you have a structure, just share it with us to give you any pointers.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  August 25, 2017 at 10:43 am

  #1956892

  This is known in the business world as BOM, or Bill Of Materials.   That's another avenue you can investigate online, in addition to the excellent suggestions Luis has made.

  Steve (aka sgmunson)
  Rent Servers for Income (picks and shovels strategy)

• calvin.clay

  SSC Rookie

  Points: 37

  More actions

  August 25, 2017 at 5:33 pm

  #1956959

  Thanks Luis and Steve!  Luis, I got to try those links and Steve, I'll do a search on sql and BOM to see what's out there.

  Calvin