Would it be possible to encapsulate the file and rows within XML tags, and then create an XML schema that would determine how to parse each row type?

I see what you're trying to point out, but keep in mind that the basis for checking individual records is 1:1 because the lookup is joined on the primary key,...

I want the result to be specific to a decimal, not averaged to the whole or half number value. See my working code.

Declare @dtDOB smalldatetime

Declare @dtDate smalldatetime

SET @dtDOB =...