Eralper (7/10/2009)

---

Hello all,

I have placed the XML string split logic into a user defined function and I think running the split within the function results better in performance than keeping...

OK. Here's what I have so far.

Try it out and let me know how it goes.

Explanations are in the comments.

;WITH AllClaims AS

-- first get all of the claims for all...

Also, you definitely do not need to use UNION here.

Because you are selecting from multiple tables, your data will always be DISTINCT.

Switch to UNION ALL and you will see improved...

Good post. I'm looking into it.

Question: Is there any chance of normalizing these tables? Your problem would be a lot easier to solve if you had a Claims table with...

yaya1899 (7/2/2009)

---

Hi Goldie,

If just create some table variables with some data, how could I simulate the situation without the same structure? Sorry, just couldn't find a way to create the...

yaya1899 (6/29/2009)

---

Thanks for your advice, David.

Hi Goldie,

Sorry, I was trying to create some sample data with similar conditions but no luck, the structure is too complicated.

1. I have to use...

Why don't you use SQL Server XML functions instead of OPENXML?

I believe performance is beter as well.

http://www.mssqltips.com/tip.asp?tip=1609

If you want a more specific answer, you need to post your XML.

Firstly, you have not given enough information about your problem.

If you give some sample DDL and DATA people would be more than willing to try to help you out.

Some questions...

Cool concept and well written article, but this is not the best way to split a string.

I've performance tests on this and the SQL while loop.

The XML version seems slick...

Excellent article!

Very clear and informative!

Jeff Moden (5/23/2009)

---

{approaching sensitive problem very carefully} If I understand correctly, this is a stored proc that processes a single row? If it's used in conjunction with a GUI,...

For some reason when I use GetDate() I always get zero.

When I use the view I get some value, usually under 100 ms.

I'm thinking that's because SQL Server dates are...

I'd love to see your procedures, even though I don't know that they'll be useful in this case.

Sure, the elapsed time is the first thing the user notices. Just keep...

Florian Reischl (5/19/2009)

---

Goldie Graber (5/19/2009)

---

Yup, sure do.

Do you mean to say that the CPU time is total of ALL processors?

If so,...

Yup, sure do.

Do you mean to say that the CPU time is total of ALL processors?

If so, I guess I should...