Production BOM


 Hello,

 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 ?
codepressAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tbsgadiCommented:
Hi codepress,

Have a look at the following tips
http://www.mssqltips.com/tip.asp?tip=938


Good Luck!

Gary
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Auric1983Commented:
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.

0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

tbsgadiCommented:
Did you manage to do what you wanted?
0
codepressAuthor Commented:
No,

None of the links was very helpful. Am thinking of upgrading the database to SQL 2005 and doing it from there.
0
tbsgadiCommented:
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). "
0
Auric1983Commented:

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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.