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