Viewing 15 posts - 946 through 960 (of 5,502 total)
SQL Kiwi (9/17/2011)
Hey Steve,Six posts to go.
Cheers.
I'm not sure but it seems like your calculation seems to be slightly off... (by two posts :-D)
September 17, 2011 at 6:21 pm
What did your search for the split function return? 😉
September 17, 2011 at 9:24 am
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...
September 17, 2011 at 4:43 am
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...
September 17, 2011 at 3:01 am
And where did you bury the client? :ermm:
September 17, 2011 at 2:54 am
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...
September 17, 2011 at 2:51 am
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...
September 16, 2011 at 3:59 pm
Please also post the code for the IARTS.dbo.CDV() function.
September 16, 2011 at 3:21 pm
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...
September 16, 2011 at 3:07 pm
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...
September 16, 2011 at 2:09 pm
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...
September 16, 2011 at 2:01 pm
The PARTITION BY argument of the ranking functions can be seen as an "implicit GROUP BY".
September 16, 2011 at 1:26 pm
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...
September 16, 2011 at 1:14 pm
Another information that has been asked for is the actual execution plan.
As a pot shot I would probably extract the relevant data from Medication and Allergy into a temp table...
September 16, 2011 at 10:49 am
GilaMonster (9/16/2011)
Another request:
I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction...
September 16, 2011 at 9:37 am
Viewing 15 posts - 946 through 960 (of 5,502 total)