We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
INSERT INTO [#TEMP2] (mpl_id, Last_Name, First_Name, DOB, Addr1, Add2, City, ST, Zip) SELECT mpl_id, Last_Name, First_Name, DOB, Addr1, Add2, City, ST, Zip FROM [#TEMP1] WHERE (HP_Last_Visit = (SELECT MAX(HP_Last_Visit) AS HP_Last_Visit FROM [#TEMP1] AS l WHERE (Last_Name = [#TEMP1].Last_Name) AND (First_Name = [#TEMP1].First_Name) AND (DOB = [#TEMP1].DOB)))
Join the community of 500,000 technology professionals and ask your questions.