This is a shortened version of the working code. In the full version there are a lot more CASE statements for each section.

CREATE PROCEDURE dbo.sp_employeecalcfields(@Company int,@EmployeeId bigint)

AS

SELECT

--...

I have it working using a case structure right now, but it just does not seem to be like the most efficient way it could be done. I end...

This method would work if I was looking them up one at a time and there was only one default flag in the table, but there is a default flag...