• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1136
  • Last Modified:

Production BOM


 Has anyone worked on a recursive query on sql 2000. On sql 2005 its done using the recursive query CTE, this is not there on SQL 2000. Any code available for this ?
4 Solutions
Hi codepress,

Have a look at the following tips

Good Luck!

In SQL 2000 you could accomplish this by using temp tables & a cursor.
Just need to be careful using cursors as they aren't the most preferred method in the world.

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Did you manage to do what you wanted?
codepressAuthor Commented:

None of the links was very helpful. Am thinking of upgrading the database to SQL 2005 and doing it from there.
That's basically the information from the link I sent
"In SQL Server 2000 there is no simple way to create recursive queries that have several levels of data (hierarchical data). "

in SQL 2000, the only way you could accomplish this would be to use a stored procedure, cursor and temp tables.

Loop through each level of the BOM and when a Made-In Item is found expand it, and so on.

Do your Bill's of Material have a set limit for how deep the hierarchy can go or is it n+1 possibilities, a set limit is sometimes easier to code.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now