Could you be more specific please?

Have a look to BOL for INTERSECT/EXCEPT

This should work, too:

SELECT N'™'

ROFL!

Sounds like a Turkish food :hehe:

lmu92 (6/27/2009)

---

@Flo:

In the post you referred...

smsam1,

could you provide some sample data to explain your question please?

Jeff Moden (6/26/2009)

---

Florian Reischl (6/26/2009)

---

lmu92 (6/24/2009)

---

Hi folks,

would someone with execution plan background mind to take a look at this post and verify if I'm on the right track or misguiding...

Glad we could help. 🙂

Seems to be a problem with ADO/ODBC and ASP have a look to this KB article http://support.microsoft.com/kb/306345/en.

The error description is different, but the error code is equal. Maybe this helps.

:hehe:

As I wrote, SUM is a function to aggregate multiple rows into one like:

Name AnyNumber

ABC ...

Try without the SUM. I'm not the reporting pro, but usually SUM is a aggregate function. Try "Fiel1 + Fiel2 + Field3 + Field4 + Field5"

Jeff Moden (6/26/2009)

---

Florian Reischl (6/26/2009)

---

Can't answer your question but the new article by Adam Machanic is really good in my opinion:

The Hidden Costs...

Can't answer your question but the new article by Adam Machanic is really good in my opinion:

The Hidden Costs of INSERT EXEC

lmu92 (6/24/2009)

---

Hi folks,

would someone with execution plan background mind to take a look at this post and verify if I'm on the right track or misguiding the OP?

The more interesting...

Jeff Moden (6/26/2009)

---

Florian Reischl (6/26/2009)

---

Jeff Moden (6/26/2009)

---

Heh......

First, I'm also completely unsure what you are trying to do with your XML. Anyway, try this:

SET @FeatureList.modify('

replace value of (FeatureList/Feature/Read[text()='' "True" '']/text())[1]

with '' "False" ''

')

SELECT...