Very Clever on the datediff stuff. Thanks for the rest as well. It appears to be what I needed.

Thanks,

Brian

Thank you.

That is exactly what I wanted. Thank you so much. Could I get a bit of an explanation as to why it works as it does. I've...

--Build Employee Table.

CREATE TABLE #Employees(

[Id] [int] IDENTITY(1,1) NOT NULL,

[EmployeeID] [nvarchar](30) NULL,

[EmployeeName] [nvarchar](50) NULL,

[EmployeeSSN] [nvarchar](50) NULL)

INSERT INTO #Employees(EmployeeID, EmployeeName, EmployeeSSN) values ('01-003-0001', 'Graham, Jarvis', '***-**-4830')

INSERT INTO #Employees(EmployeeID, EmployeeName, EmployeeSSN) values...

Here it is:

--Build Employee Table.

CREATE TABLE #Employees(

[Id] [int] IDENTITY(1,1) NOT NULL,

[EmployeeID] [nvarchar](30) NULL,

[EmployeeName] [nvarchar](50) NULL,

[EmployeeSSN] [nvarchar](50) NULL)

INSERT INTO #Employees(EmployeeID, EmployeeName, EmployeeSSN) values ('01-003-0001', 'Graham, Jarvis', '***-**-4830')

INSERT INTO #Employees(EmployeeID, EmployeeName,...