I came up with the following script.

INSERT INTO [dbo].[TORateFY] (Year,HistoricalHC,NumbTermedEmp)

SELECTDISTINCT YEAR(GETDATE()) AS [Year],

SUM(CASE WHEN EmpStatusName = 'Active' THEN 1 ELSE 0...

Thank you for the response.

I actually ended up using a suggestion from another forum that worked out really well.

The moderator there helped me to put together a Script...

Yes, there can ba a situation where there is a middle initial and a suffix.

However, there will not be an issue with 2 middle initials. The system we use...