I would like to thank everyone for their input on this matter but I have resolved the issue. I created a temp table called PHONE and selected the phone...

Yes, the columns in the dbo_PersonPhone table are -

PhoneID

TelephoneTypeID

PhoneNumber

dbo_HomePhone has many columns with the PK being PhoneID.

Won't this query just compare on a single line basis? What I mean is, I need to compare the end date of each account number with the start date...

I use the CONVERT(VarChar(10), StartDate, 101) function to format the dates in MM/DD/YYYY format.

Thank you for the help. I created a permanent table and everything executed the way it should.