Thanks, Atif.

Thanks for the Feedback, Chriag!

In all fairness, I should point out that sometime after I posted...

Jeff Moden (8/4/2008)

---

What an amazing article! Covers most everything from womb-to-tomb for such an "impossible" delete. I remember being amazed when Barry first posted his solution on the...

Please see this link for instructions on how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Suggestion: Temporarily add an XML column to your table and store the entire EVENTDATA in there.

Then you can query the actual EVENTDATA interactively, until you figure out what is...

post the SQL script.

KMM (8/4/2008)

---

I have tried various temp tables, but this is where it is tricky, which is why it was in a cursor, each row that it processes depending on the...

The smiley's appear when you have a space followed by a ")" followed by a space or an end-line. I try to put a tab or a character in...

good luck and thanks for the feedback.

You should note that my technique preserves the "time" part of the dates (including Getdate()) instead of knocking them down to midnight. This might produce slightly different results than...

please do not cross-post.

Either in pre-processing (the Load step of the ETL) or in post-processing (the Analysis client). ...

Try it like this:

ALTER procedure [dbo].[usp_GetDupes]

(@days int)

as

SELECT RX_NUMBER, FD_FACILITY_ID, POS_POS_FINALIZATION_NUM,

COUNT(RX_NUMBER) AS TALLY

FROM POS_DATA

WHERE POS_POS_FINALIZATION_NUM IN

(

SELECT POS_POS_FINALIZATION_NUM

FROM POS_DATA

GROUP BY POS_POS_FINALIZATION_NUM

HAVING (COUNT(POS_POS_FINALIZATION_NUM) > 1)

) AND

AND POS_DATESTAMP BETWEEN DateAdd(Day, -@days-1,...

There's not much that I can...