Made a simple change to the data and broke my own code. This requires additional information regarding he requirements. If the data is inserted as specified by the...

Scott Roberts (4/27/2009)

---

Actually, it doesn't.

Check your results against the "expected results" in post...

Actually, its broke, something was missing. Ignore the current code, i need to rework it a bit.

Possibly, but based on the trivial data, table structure, and expected results provided, it...

How about this?

EDIT: Code posted here was removed as it failed!

I noticed that your table def had RawData defined as varchar(5000) but your cursor function had it defined as varchar(300)....

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...