Jeff Moden (6/17/2008)

---

Heh... I've got 100 PM's that I really want to keep... and Steve hasn't developed a way for me to download them, yet and I've been too busy...

This works, though I honestly have no idea why:

select T.Loc.value('(/XML/Institution/@Id)[1]','uniqueidentifier') AS [Institution]

, t.Loc.query('.').value('(/User/Email)[1]','varchar(128)') AS [Email]

, t.Loc.query('.').value('(/User/BusinessRoleGuid)[1]','uniqueidentifier') AS [BusinessRoleGuid]

FROM @x.nodes('/XML/Institution/Users/User') AS T(Loc )

🙁 *sigh* XML queries just remain so...

Du'h, it's not the SQL2005 forum... :blush:

Ah, it's SQL, not CLR. It looks like the Triangular Concatentation problem (ie., sequential cumulative string concatenation is O(n²), esp. with immutable strings), which is solvable in CLR, but...

it's in there, it's just hard to see... 🙂

I think that you have to at a minimum include '. + -' in that list.

Matt Miller (6/17/2008)

---

Yup - I can fix the one issue on tempDB, but it still performs rather poorly on few, big groups. So - while it can beat the...

Still haven't answered my question.

Thanks Jeff, I've added it to my briefcase.

Try this:

Select * from Table2

Where IsNumeric(JoinColumn) = 0

This is the most straightforward way, though not the fastest.

Insert into ProcessedTable(OrderNumber, LineItemNumber, LineItemDesc)

Select OrderNumber, LineItemNumber, MAX(LineItemDesc)

From OriginalTable

Group By OrderNumber, LineItemNumber

Having COUNT(*) =...

Wilfred van Dijk (6/16/2008)

---

I agree with Bob. Why write some unreadable code in order to avoid cursors? To my opinion, cursors are easy to implement, very straightforward and the extra...

Cool. I stand corrected. 🙂

OK, I checked and unfortunately I do not have much useful stuff that...