quote:
...Could you give an example with this column structure. I just want to make sure I understand...
Sorry took so long to get back; went home for the day! 🙂
Here you go:
CREATE TABLE new_property
(
UserID INT NOT NULL,
MLSNum INT NOT NULL,
DateInserted DATETIME NOT NULL,
CONSTRAINT PK_new_property PRIMARY KEY ( UserID , MLSNum )
)
GO
INSERT INTO new_property(UserID, MLSNum, DateEntered)
SELECT sp.UserID, sp.MLSNum, sp.DateEntered
FROM saved_property sp
INNER JOIN (SELECT sp1.UserID, sp1.MLSNum, MIN(sp1.SavedID) AS SavedID
FROM saved_property sp1
GROUP BY sp1.UserID, sp1.MLSNum
) AS derived_property dp ON sp.SavedID = dp.SavedID
Hope this helps,
Jay