Here's a simple solution which assumes only three levels in the hierarchy, as in your sample data. Note how the sample data has been set up using a script:

DROP TABLE...

What tool are you using to "download data"?

Can you post the query you are using?

Dave Ballantyne (9/27/2010)

---

Anyone else going to be at SqlBits this week, have to say ive still got no idea how i got onto the Friday (Well known Speaker ?!?!)...

Mor... no better not.

Happy mornings!!

[code="sql"

update ds_CleanNames

set clean_name1 = LEFT(clean_name1, CHARINDEX(' DBA...

rhinotillexo-freakin'-mania

Thanks for clarification. Here's a little added value...

DROP TABLE #ds_CleanNames

CREATE TABLE #ds_CleanNames (clean_name1 VARCHAR(20), Clean_Extra_Name VARCHAR(20))

INSERT INTO #ds_CleanNames (clean_name1)

SELECT 'AB DBA CD' UNION ALL

SELECT 'AB DBA CD EF DBA...

Especially when different levels of nesting have different sort criteria.

Ooh Bob you grass!

DROP TABLE #LookupInv

CREATE TABLE #LookupInv

(

DateID int,

StyleCode varchar(23),

...

Don't you want to sum the quantity over each partition?

Bob, you could...

Of course, you could turn the query around and look at rows matching on orderid where the column values are the same:

SELECT sd.OrderID, sd.ProductID, sd.BookedDate, sd.LBooked_Date, sd.SLeadTime, sd.CustDel

FROM supplydates sc...

tt-615680 (9/24/2010)

---

I have been trying to query the OR statements one at a time but it is still the same...

Have you tried following the steps recommended by Winash?