T-sql script is running in 2000 sql server not in 2008 sql server.

INSERT  INTO Appraisers
        ( ContactID ,
          FirstName ,
          LastName ,
          Company ,
          PostDate
        )
        SELECT  TopAppraiserList.AppraiserID ,
                TopAppraiserList.AFIRSTNAME ,
                TopAppraiserList.ALASTNAME ,
                TopAppraiserList.AppraiserCompany ,
                GETDATE()
        FROM    Appraisers
                RIGHT OUTER JOIN TopAppraiserList ON Appraisers.ContactID = TopAppraiserList.AppraiserID
        WHERE   TopAppraiserList.AppraiserID IS NOT NULL
                AND TopAppraiserList.AFIRSTNAME IS NOT NULL

---

sqldevelop.wordpress.com