Jonathan, check this out. I believe this is an optimal solution. Let me know if it works for you.

declare @var xml;

set @var =

'<DaddyRoot>

...

Jonathan Mallia (3/8/2011)

---

Thanks Arjun for your solution, however, what if the 'large' xml file contains 100,000 'root' nodes?

In addition, the solution returns three columns, not three rows.

Do you think...

Is this what you need? Try this out. Let me know if it does not work.

declare @var xml;

set @var =

'<DaddyRoot>

<root>

<field1>Test 1</field1>

...

BeginnerBug (3/4/2011)

1. How good is my SP skelton?

2. How can i make sure wether the procedure is executed or not?

3. how can i make sure procedure is recompiled to the...

In...

Cool. Keep coming back to SSC. 🙂

David, as Lowell has mentioned, add...

I'm afraid that won't be of much help, as you want to do the update on the parent...

Hi ken, i would need more info to give you a good explanation. I am replying from my phone now, so will keep it short.

It's not surprising that you didn't...

That's really bad design KS. Anyway, check this out, if you don't want to change the table structure.

if (object_id('tempdb..#contact') is not null) drop table #contact

create table #contact (id smallint, name...

Lol.. that almost sounds like a movie name. Good one there Steve.

- arjun

Ken Sturgeon (11/30/2010)

---

I have a query tuning question. I have a table with some 1.7 mil records and the 2 columns (SalesOrder = col1, SalesOrderType = col2) being searched on...

InfiniteError (11/30/2010)

---

i know there's an ethical problem on what im trying to do, but it already ordered to me by the higher ups, it's not my decision and i already...

Sorry to dig up an old post. Even though the poster never replied, there are other folks like me, who read this (thanks to search engines) and gain from it....

Paul White NZ (9/8/2010)

What I am doing in this first part, is showing you what horrible plans can be produced if we prevent the optimizer from using all of its...