D'oh!

Ignore last post - I have just read it

Thanks for the quick response Barry.

I don't think I can make Lynn's solution work. The file has 12,500 distinct products.

Unless I am missing something that would make the SELECT/UNION...

Hi all, and thank you all for your time! I actually thought my SQL was pretty good until I hit this problem. So, some more information as requested. The product...

Thanks for your time replying!

I have tried the query but get the following error:

--------------------------------

Msg 240, Level 16, State 1, Line 1

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