Thank you for posting the solution you found.

Much better than a "never mind, I got it" reply, or, even worse, none at all... 😉

Dick Herberts-320552 (11/17/2010)

---

Hi guys,

I'am testing the routine right now on a table with 26.000.000 records, tomorrow i will give the performance results.

Thanks very much for all your knowledge input

Have a...

WayneS (11/17/2010)

---

...

I knew there was something I was going to add to my post - THANKS LUTZ!

...

It took 3 whole seconds on your system? What'd you do, kick off a...

@Dick: VERY IMPORTANT!!!

Based on your previous note "4. No clustered index yet " Do NOT run the code until you added a clustered index that supports the order the data...

Great job, Wayne!

That's the solution I had in mind... 😉

WayneS (11/17/2010)

---

@? Is your name Dick, or Dirk?

Can you verify also:

1. That...

Depending on...

You might want to read the first article linked in my signature on how to post sample data.

Please include the clustered index definition, since it's crucial to decide which option...

Here's the Cross Join syntax together with the string concatenation.

As a side note: I had to modify your sample data script to actually work. It's good practice to test such...

There are basically two approaches:

1) insert the data into a new table with an IDENTITY column to get consecutive New_ID's (maybe using an auxiliary column to get it formatted properly)...

You might want to start with CROSS JOIN on those three tables.

Unfortunately, there is no rule that would explain why there is no entry for

BrandNameTwo ProductNameOne aviator eyewear

or any...

I'm not sure if it's th fastes possible solution, but here's how I'd do it:

Step 1: get the list of distinct AccountID's

Step 2: Build a "master list" by cross referencing...

Spam reported.

ROTFLMAO

Did you try to run the statement step by step?

Something...