I may be wrong, nothing available to do any testing, but isn't this the equivalent of the code you originally posted above?

SELECT

M.MainTableID,

M.PageName,

...

Here is another method:

create table #Orders (

OrderNum int,

LineNum int,

Product varchar(10),

Result varchar(25)

)

;

insert into #Orders

select 1,1,'ABC',null...

aaronxramirez (4/27/2009)

---

Just stepped in for a quick read up on the article...good article, however the examples are a bit naive and are not applied toward anything I would have ever...

Samuel Vella (4/27/2009)

---

Steve Jones - Editor (4/27/2009)

---

For the email solution, we run a .NET app here to send the mail, offloading the load of XP_sendmail from SQL Server. We grab...

Here is an example of how to use the STUFF...FOR XML using the example from AdventureWorks:

Set NoCount On;

Declare @cpu_ int;

Declare @lreads_ int;

Declare @eMsec_ int;

Select

@cpu_ = cpu_time,

...

ALZDBA (4/27/2009)

---

As you suggested the "Order by" testing with Jeffs solution, I also tested your marvellous solution for partitioned objects.

First findings .... It no longer works .... SQL2008 ( sp1...

Very good article. In fact, I'm thinking of printing each of the articles in the series and providing them to my team as required reading.

The test harness you have...

RBarryYoung (4/26/2009)

---

(copied from my blog):

For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from...

Bob Hovious (4/25/2009)

---

How about this one? Fresh off the presses...

1. Create temporary table "A"

2. Populate it with base ids

3. Query table "B" and update one...

Florian Reischl (4/25/2009)

---

Hi

New information from splitter front... 🙂

As first I have to apologize for all those "great" CLR test results... Since I tried to reduce the test results to the...

manohar (4/24/2009)

---

Hi Lynn..

Will it be extra overhead if I create indexes on temporary tables..??

As that procedure will be frequently used ..... Temporary table will be created and deleted,. Indexes will...

Jeff Moden (4/24/2009)

---

Lynn Pettis (4/24/2009)

---

Jeff, Do you have access to SQL Server 2008? At the SSWUGvConference I heard the the ORDER BY "may be" honored again in the UPDATE...

Jeff, Do you have access to SQL Server 2008? At the SSWUGvConference I heard the the ORDER BY "may be" honored again in the UPDATE statement. I don't...

As this is done inside a stored procedure, I'd drop using a table variable and use a temporary table instead. If there are a large number of records in...

Be sure to post your final solution. It may help others with a similar issue/problem.