doesnt answer your question....but if you are looking for a free SQL refactoring tool that is configurable

http://www.apexsql.com/sql_tools_refactor.aspx

....Note...I do not work for these guys

maybe I am wrong (probably:P) but I don't think I have seen a solution that correctly parses
INSERT INTO #Weights
VALUES
('14lb 7.6oz')  ---- note no spaces between...

me thinks you need a join between "band" & "event" tables to start.....shouldn't be very difficult

for these records

10000003 | 10000004 
-----------------------------
10000005 | 10000006 

why arent there corresponding reverse entries?.......or am I misunderstanding your post?

possibly something along these lines...??

;WITH
    cte_FixData AS (
        SELECT
            r.R23_SQL_ID,
            r.PROP_CODE,
            r.TENANT_NUMB,
            From_Date = CAST(r.DATE_CHANGED_SQL AS DATE),
            r.TOT_DEB_VAL    ,
            ROW_NUMBER() oVER (PARTITION BY r.PROP_CODE,    r.TENANT_NUMB,    CAST(r.DATE_CHANGED_SQL AS...

maybe its the way my brain works ...but I cannot accept that 4 different DOBs produce the same result.

SELECT * from dbo.AgeCalculation(' 2017-01-27 ','2017-03-01','md' ) --...

a few q's......you have posted in SQL 2005 forum...pls confirm this is the version you are working on.
can you post expected results from your sample set up...so we know...