How about sending the last few hundred (?) posts to DiscoveryChannel? They might be able to make a few stories out of it... 😀

Very entertaining for an ESL who has...

Brandie Tarvin (2/18/2011)

---

Thank you all for answering my questions. I appreciate it. I never viewed indexes that way before. I guess I still have a lot to learn.

And I forgot...

christophe.bernard 47659 (2/18/2011)

---

Hi GSquared, LutzM

thanks for your time and your knowledge ..that's work ..yes 🙂 🙂 !

I'm a beginner with t sql and i'm not sure to understand your code...

Please don't start a new thread if you have additional information to a question already posted.

Original post including a first reply can be here

please read and follow the advice given in the first link refernced in my signature and provide ready to use test data together with your expected output and what you've...

Must be a pain for the camel. (They still use bricks for it, right?) :pinch::crying:

I'd use either a LEFT OUTER JOIN or a NOT EXISTS subqry.

Brandie Tarvin (2/17/2011)

---

Paul,

What is the effect of building a non-clustered index over a clustered index?

The table already uses CoverageKey and Effective (both ASC) as it's clustered index. Include only works...

I'd rather go with

SELECT

x.i.value('(@parentStructId)[1]','int') AS ParentStructID,

x.i.value('(@family)[1]','int') AS Family,

x.i.value('(@subFamily)[1]','int') AS SubFamily

FROM @xmlFile.nodes('/FamilyAndSubFamily/myStruct') as x(i);

It performs better than the x.i.query('.').value approach. (see execution plan and statistics on a larger data volume)

LutzM (2/16/2011)

---

How do you come to this conclusion?

Examples:

Product 2 is available until 2-8-2011. How do you know it's not available after that?

Product 5 is not available starting from 2-9-2011....

How do you come to this conclusion?

Examples:

Product 2 is available until 2-8-2011. How do you know it's not available after that?

Product 5 is not available starting from 2-9-2011. How...

Without any more details (like table def, sample data, expected result and the like) it's hard to tell.

My guess would be there are more than one rows with nome ='Albertino...

Pouliot Philippe (2/16/2011)

---

Do you think Certification for sql Server 2005 is to "old" now ?

Or i must will go with Exam 70-432(Sql Server 2008)

What do you think about that...

Rich Yarger (2/15/2011)

---

I'm almost there...How do I get the result set now into the table? I've tried all the normal methods of SELECT INTO and SELECT / INSERT INTO,...

GilaMonster (2/15/2011)

---

LutzM (2/15/2011)

---

Wouldn't index 1 be used if a...