SELECT  sp.CompanyID ,
                SalespersonCD = sp.EmployeeCD ,
                UsrInitDate = COALESCE(BL.TranDate, sp.EndDate) ,
                sp.EndDate ,
                leavePerson.LeaveDate
        --INTO    #tmpSalesmanInfo
        FROM    THPDMS2..DMSSalesForce sp
                LEFT JOIN ( SELECT  SalePersonCD ,
                                    TranDate = MIN(TranDate)
                            FROM    [dbo].DMSBLFCS AS FCS
                            WHERE   FCS.RouteID != 'Other'

                            GROUP BY SalePersonCD
                          ) BL ON BL.SalePersonCD = sp.EmployeeCD
                LEFT JOIN THPDMS2..DMSSurveyLeaveSalesperson leavePerson --ON leavePerson.CompanyID = sp.CompanyID
				--	AND
                ON leavePerson.SalesmanID = sp.EmployeeCD
                   AND leavePerson.CompanyID = 3
        WHERE   sp.CompanyID = 3
        GROUP BY sp.EmployeeCD ,
                sp.EndDate ,
                BL.TranDate ,
                leavePerson.LeaveDate ,
                sp.CompanyID