INSERT INTO TableB (ComputerName, othercolumns...)
SELECT ComputerName,othercolumns...
FROM
(
SELECT MAX(CASE WHEN AuditId='000.' THEN AuditDate END) OVER (PARTITION BY ComputerName) AS ZeroDate,
MAX(AuditDate) OVER (PARTITION BY ComputerName) AS MaxDate,
*
FROM Table
)t
WHERE MaxDate = ZeroDate

quote:

---

Originally posted by eirikr_1

Hello James
Since there is no vulnerability found after 2/1/13. I want to move all As to a historical table.
With computer C, Although I found no Vulnerability on 1/1/13, however the scan shows another
Vulnerability found on 2/1/13. So I don’t move the computer C record.
Thank you for help

---

quote:

---

Originally posted by eirikr_1

All three records related to A will be moved.
Assuming on 2/2/13 scan show another vulnerability found with auditId 1234, then all 4 records related to A wont be moved. It means this computer need to be patched. Thank you with respecful

---