DECLARE @DateFrom DATE = '2015-01-01', @DateTo DATE = '2015-12-31'

DECLARE @NewLoanOfficerID INT, @tmp INT
CREATE TABLE #LoanOfficers ( loLoanOfficersID INT )
CREATE TABLE #LoanOfficersUpdated ( loLoanOfficersID INT )

INSERT INTO #LoanOfficers ( loLoanOfficersID )
SELECT TOP 5 loLoanOfficerID
FROM loloan
WHERE AgreementDate BETWEEN @DateFrom AND @DateTo
GROUP BY loLoanOfficerID
ORDER BY COUNT(loLoanID) DESC

SELECT TOP 1 @NewLoanOfficerID = loLoanOfficerID
FROM loloan
WHERE AgreementDate BETWEEN @DateFrom AND @DateTo
GROUP BY loLoanOfficerID
ORDER BY COUNT(loLoanID)

SELECT TOP 1 @tmp = loLoanOfficersID FROM #LoanOfficers ORDER BY loLoanOfficersID DESC

WHILE @tmp IS NOT NULL BEGIN
	UPDATE dbo.loLoan SET loLoanOfficerID = @NewLoanOfficerID WHERE loLoanOfficerID = @tmp
	INSERT INTO #LoanOfficersUpdated ( loLoanOfficersID )
	VALUES ( @tmp )
	SET @tmp = NULL
	SELECT top 1 @tmp = loLoanOfficersID FROM #LoanOfficers WHERE loLoanOfficersID NOT IN ( SELECT * FROM  #LoanOfficersUpdated ) ORDER BY loLoanOfficersID DESC
END

DROP TABLE #LoanOfficers
DROP TABLE #LoanOfficersUpdated