SELECT * FROM (
	SELECT (((kpiTotal.Actual * kpiTotal.TotalWorkingday)
	/(kpiTotal.Target * kpiTotal.MTDWorkingday))* 100) PercentAchived, * FROM (
	SELECT saleTotal.*, id.[From], id.[To], id.Incentive
	FROM MRCDMS..DMSKPIIncentiveDetails id
	INNER JOIN (SELECT sale.SalespersonID, sale.TotalWorkingday, sale.MTDWorkingday,
	 t.KPIID, t.Target, t.Actual, t.KPICD FROM #tmpResult t INNER JOIN
	(select  SalespersonID ,
            ISNULL(SUM(wrk.TotalWorkingday), 0) AS TotalWorkingday ,
            ISNULL(SUM(wrk.MTDWorkingday), 0) AS MTDWorkingday
    FROM    ( SELECT    SalespersonID ,
                        COUNT(DISTINCT VisitDate) AS TotalWorkingday ,
                        0 AS MTDWorkingday
              FROM      MRCDMS..DMSVisitPlan o
              WHERE     DATEDIFF(mm, GETDATE(), VisitDate) = 0  and o.CompanyID = @_CompanyID
              GROUP BY  SalespersonID
              UNION ALL
              SELECT    SalespersonID ,
                        0 AS TotalWorkingday ,
                        COUNT(DISTINCT VisitDate) AS MTDWorkingday
              FROM      MRCDMS..DMSVisitPlan o
              WHERE     DATEDIFF(mm, GETDATE(), VisitDate) = 0
                        AND DATEDIFF(dd, GETDATE(), VisitDate) < 0
						AND o.CompanyID = @_CompanyID
              GROUP BY  SalespersonID
            ) AS wrk
    GROUP BY SalespersonID) sale ON t.ObjectID = sale.SalespersonID ) saleTotal
	ON id.CodeListSalesID = saleTotal.KPIID ) kpiTotal) tempTotal
	WHERE (tempTotal.PercentAchived >= tempTotal.[From]
	AND tempTotal.PercentAchived <= tempTotal.[To])