add new time stamp

Select CTBC.IdContactType, CTBC.IdCustomer, C.Name, C.LastName, C.IdCustomerEstatus, cd.HourlyRate from ContactTypeByCustomer CTBC join Customers C on CTBC.IdCustomer = C.IdCustomer join EmployeeContractDetails cd on cd.IdCustomerEmployee = c.IdCustomer and getdate() between ContractStartDate and isnull(ContractDueDate, '9999-12-31') Where CTBC.IdContactType = 1 and C.IdCustomerEstatus = 4 Order by C.Name, C.LastName

Does these resources performed the same task?

 yes  no

Do the worked during the same period?

 yes  no

add new time stamp