Here's my sample code for the bill of material explosion problem. Using the BOL article on "Expanding Hierarchies"... I took the example code and modified it as below....

Hi Jeff,

I got your .net email and have sent a test reply to it.....

Hi Jeff,

Many thanks for your email, which did arrive. I replied but got an undeliverable notice. Can you resend to my email address again, maybe with an alternate...

Hi Jeff,

I can't see any spam in my junk mail... or anything in my PM box....

Many thanks for the reply Jeff. I'll work on a test routine as per your first link in your signature block.

With work pressure it could take me a few...

Sorry again to reopen an old thread.

I'm using SQL Server 2000. Thus CTE is not available.

I need to expand BOM's.

The BOL feature on Expanding Hierarchies is great. And...

Hi Eddie,

Yes, that's what I needed to do - sum the individual duplicate counts... to reconcile against the total number of rows in the table.

Great, thanks Mark. That makes sense. Pity the error message didn't tell me to add a name for the derived table, instead of just saying "Syntax error near...

Thanks Mark-101232. Brilliant. 🙂

But I had already tried this, without the final x, which gives me a syntax error.

What does the final x do? (Apart from...

I frequently need to examine data in tables when I am developing new stored procedures. Often times because the user departments wanting the new programs don't really fully understand...

Good effort Sarvesh.

See also QOTD:

http://www.sqlservercentral.com/questions/T-SQL/70386/

🙂