That Worked great!!! , thank you very much !!! I was able to update 130,000 records in 1 pass!!

Vinu , thank you for all your help, just to clarify , the mary smith record was a typo (mistake) when i was cutting and pasting , basically i have...

This is basically the schema , im only interestead in updating the Expiration date based on the primary member ( pass holder)

/****** Object: Table [dbo].[Passes] ...

Thank you for the help , the problem i ran into with your solution is that i have more than 1 person who is the primary so i basically get...