Jeff Moden (3/6/2009)

---

If someone ever starts sending you data with milliseconds, you code will produce incorrect results. If some newbie in a hurry sees your code and decides it...

andrewd.smith (3/6/2009)

---

I did a DATEADD function to add 86399 seconds to the dates, making them the equivolent of 23:59:59, since that seemed to me to be the easiest way to...

An internal solution to our problem was found. Below is the code we used...

Thanks for everyone's help!

DELETE FROM DELRCRD

FROM ReportingTable DELRCRD JOIN

(SELECT REVIEWID, MAX(LOCALRVWUDATE) AS MAX_DATE FROM ReportingTable

GROUP BY...

I think this willl work. The code design has been kept true to its original state.

DECLARE @RPTStart INT, @RPTEnd INT, @LOC CHAR(50)

Set @RPTStart = 1090101

Set @RPTEnd = 1090131

Set @RPTStart...

Luke L (2/2/2009)

---

I think you could look at 2 things that would help you greatly...

First, I'd have a talk with the dev team for the front end. Perhaps this...