Oh, and please do remove all that XML from your original post and include it as an attachment. It's slowing down the page-render so badly I actually had trouble...

This should get you started:

DECLARE @X XML = '...copy your XML here...';

SELECT X.SR.query('.').value('declare namespace RS="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition";(/RS:Subreport/RS:ReportName/text())[1]',

...

Your XML is malformed, probably because of copy-and-paste into a website. Take a look at line 1045. Getting an "Illegal character" error on that line when I try...

Okay, here are some questions on this:

1. How does the database know which product comes first, which one second, et al, or does that not matter?

2. You have three products...

The reference you linked to is a good intro to it.

It doesn't mention the effects of implicit conversion that can kill SARGability between data types.

And it uses IN (x,y,z) as...

Definitely not just UDFs.

It's pretty much anything other than an equality comparison between a column and another column or between a column and a variable, and in both cases it...

The option you posted, Marko, is what's called a "triangular join", and it will work just fine on very small datasets, and will absolutely die on large datasets. So,...

It's like any habit.

Start doing it.

Remind yourself any time you catch yourself not doing it.

Soon you'll be doing it pretty automatically.

It takes work to remember at first, and then gets...

Stefan Krzywicki (11/2/2011)

---

I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done run...

It's an infinite list, since you can include UDFs in it.

What is it you're trying to solve?

Yep, namespace matters!

Glad I could help.

The documentation for XQuery is junk. I've been through a lot of headaches working it out, so anything I can do to help others...

I've been a computer hobbyist and "power-user" since I was about 8 years old, but I only got into actual IT (DBA) work 11 years ago.

The way I got into...

Takes a bit, that's for sure. There's a lot to wrap your head around.

The execution plan tells a bunch of the story of what's going on here. It's scanning the same clustered indexes over and over, and doing a lot of work...

You'll want to expand that conversion to something more than Varchar(1). That will only hold one character, and kind of defeats the whole purpose of what you're doing here.

Make...