Not trying to knock Mark at all and I apologize if it sounded that way. I appreciate any and all suggestions.

Thank you Mark

Thanks Mark but that did  not work. Here's the query:

SELECT     LDR.LoanNumber

              ,LDR.StatusCode

              ,LDR.StatusCodeDate  

              ,LDH.Item

FROM       viewLoanDatatotalRetail AS LDR

INNER JOIN tblLoanDataLockHist AS LDH ON LDH.LoanNumber = LDR.LoanNumber

WHERE LDH.Item = (SELECT MIN(LDH.Item) FROM...

For most companies, the HR interview is the first line of defense. The questions asked are typically used to determine the following:

1) Your motivation for their position or your career path.

2)...

Have you thought of changing the TrunkGroupID column to use identity? If you are just incrementing based on the existing columns max value then using the identity property of that column should...