A few (standard) things that I spotted:

a) don't use a table variable with such an amount of data. Use a temp table with proper indexing instead so you can benefit...

Just remove the barckets and quotation marks from your variable reference:

SELECT * FROM #Test WHERE col2.exist('/root/tag1[@level=sql:variable("@var")]') = 1

What column do you want to use in your table referenced in the APPLY statement?

Either way, it most probably won't work the way you probably have in mind...

If you want...

It depends on the table structure you've used to store this information... 😀

But if you're looking for time zones per country, SQL Server is the wrong source to start with,...

Please provide DDL for a sample data together with some sample records and your expected results. Based on your verbal description it gets confusing (to me, at least...). Please read...

Please try to run your code in TempDB. You'll find that it's not runable at all, even after 10 or so corrections...

Would it help to add %2 = 0 (modulo of division by 2) to your current group calculation? Or divide the group number by 2 (assuming it's an integer).

You folks down in CA have a weird understanding of bowling... Do you at least use...

I guess as long as we're not forced by db collations we're getting lax "by nature"...

At least I do. :blush:

Dan, I urge you to put that pistole down!...

Oh, I forgot: if the process is performance crucial, you should think about shredding the xml into properly indexed relational tables... 😀

BobA 66314 (4/26/2010)

---

Thanks. XQuery does the work!

I use OPENXML because it is faster, and the task occurs while online user waits. Any idea why it ignores this one...

The benefit for storing data in the cloud is simply to save money. But the very same department that actually benefits from that (financial dptmt.) is unlikely to put their...

I would try to do it set based as much as possible:

If the last step is DELETE then DELETE the sequence order if it exist.

If the last step is INSERT...

It seems like you're still using OPENXML instead of XQuery even though you're already on SS2K8, obviously (guessing based on the syntax and the DATE data type...).

When using XQuery it...