Dwain,

I did remember to cast to varchar but may not have matched the actual length of varchar in the table. Can you tell me why this exact match would be...

Correction....those errors were due to my sloppy typing....but back to the original error:

Msg 240, Level 16, State 1, Line 1

Types don't match between the anchor and the recursive part in...

Dwain,

I appreciate your interest and effort on this. I would like to find a more efficient way to handle this but after changing the ITEM1 and ITEM2 to the...

I had another suggestion (from a different forum) that provided a solution. It may not be the most eloquent but it ran on 98K rows in 8 minutes.

This is...

On a quick read through I noticed your data type is int. This would drop the leading zeros on many of my skus. When I run this with...

Thank you Dwain. I'll read through the code and give it a try this morning!

I appreciate the dialogue here and I am benefiting from it. Dwain, I re-ran your code on your small example and it worked this time....no idea why. It...

Dwain,

As a follow up. There seems to be an issue related to the process order of the data (I know...there is no actual order). When I add an...

dwain.c (12/17/2012)

---

lmeinke (12/17/2012)

---

dwain.c (12/14/2012)

---

lmeinke (12/14/2012)

---

Steve,

I was actually replying to dwain c. but I do thank you as well. I was out of the office for a few days and...

sgmunson (12/17/2012)

---

Glad to hear it works for you, although I'm thinking there might be a better way than to just regenerate the data every time you need it. ...

sgmunson (12/17/2012)

---

Ok, I see where I had trouble. Here's a fix, but I'd be concerned about it's performance with a large volume of records. It might...

dwain.c (12/14/2012)

---

lmeinke (12/14/2012)

---

Steve,

I was actually replying to dwain c. but I do thank you as well. I was out of the office for a few days and didn't try...

Steve,

I was actually replying to dwain c. but I do thank you as well. I was out of the office for a few days and didn't try yours until...

Thank you for the code and suggestion. I did run the code and it works for all but the very first entry in an industry/category group. I will...

Jeff,

If you have any more insight into this issue I would sure appreciate it.

Thank you,

Lonnie