Ok, ok! I'll give it some thought...:cool:

Chris Morris-439714 (2/22/2010)

---

No, really! And you, Mr White, should write an article on APPLY. I'm learning tons from reading your recent posts and I'm sure I'm not alone. In fact...

Can I ask why you are wondering, and why it is so urgent? ...

Um, I have a style now? :w00t:

Duplicate thread.

I posted a comprehensive answer here:

http://www.sqlservercentral.com/Forums/Topic870098-338-1.aspx

DBCC PAGE output after running the ALTER TABLE command:

Slot 0 Column 1 Offset 0x4 Length 4 Length (physical) 4

i = 1 ...

:laugh: Yeah, right! :laugh:

That's 😎

I have a habit of using APPLY to neaten up my SELECT statements - I just like the style.

Plus, you get...

Ah yes the signal-to-noise thing. I've noticed a...

Is it just me...or are the posted questions getting better?

:smooooth:

Paul

gail_liberty (2/22/2010)

---

Unfortunately, in my case, we can't pre-process the data as it is a 3rd party application that populates the SQL table. We're just trying to export the data...

GSquared (2/22/2010)

---

Clever. I hadn't thought of using Cross Apply at that point in the query. (Use it all the time in separating out the nodes. Just never...

Ah, a small, but vital point - thanks.

Corrected version below.

DECLARE @ProductMaster

TABLE (part_code...

Woot! Were you a version 3 beta tester?

As far as the achiving thing is concerned, yes it is very...

The updated test data setup script is in my reply...