Ninja's_RGR'us (9/17/2011)

LutzM (9/17/2011)

I don't think so...

If the post count is still...

I don't think so...

If the post count is still correct, your...

I'm not sure but it seems like your calculation seems to be slightly off... (by two posts :-D)

What did your search for the split function return? 😉

Hi Anthony,

here's a first draft describing the way how I would do it. Of course untested due to missing source tables and sample data.

It might help to improve performance even...

This error is caused by two (or more) concurrent processes trying to acess/modify the same data and waiting for each other to finish.

A more detailed description can be found at...

And where did you bury the client? :ermm:

Unfortunately, there are no sample data in your post so we're left with guessing what you're looking for.

My guess: it sounds like a split string function. Search this site for...

I'm wondering why the code is written in a way that even if the first search block (match on all fields passed) returns a single CustomerNumber, the code will proceed...

Please also post the code for the IARTS.dbo.CDV() function.

You're dealing with a "catch-all"-query here. But that might be just because of the way the "outer logic" is implemented.

How do you use this sproc (What code calls it)?

It might...

Under almost any circumstances, a function will be faster than a c.u.r.s.o.r. * cough*.

Especially, if it's an iTvF (inline-Table valued function).

Depending on the size of the sproc, you could open...

It looks like the major issue is the table scan of the Diagnosis table and the Hash Match against TempMu. You might want to add an index on Diagnosis.ICD9 and...

The PARTITION BY argument of the ranking functions can be seen as an "implicit GROUP BY".

Hi Gregory, it's been a while ;-):cool:

you could try something like

WITH cte as

(

SELECT

CustomerNumber,

ROW_NUMBER() OVER(PARTITION BY CustomerNumber ORDER BY IssuedDate desc ) AS row

FROM TableA

)

SELECT *

-- DELETE

FROM cte

WHERE row...