Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
select 'Daily Production' as Category, Concat('<div style="background-color:',Color,';">$' , Format(Value, 2),'</div>') as Value , Concat('$' ,Format(Office , 2)) as Office , Concat('$' ,Format(Amount, 2)) as Expectation , 0 as DARTME FROM (Select PL.Color, PL.Performance, Value, Office, X.Amount FROM ( Select sum( Case When U.userName = 'APAY' Then ppe.Amount else 0 End) / (17) as Value, sum(ppe.Amount) / (17) / 36 as Office from wt_postpaymententries ppe Inner Join wt_PaymentAgreement PA on ppe.AgreementID = PA.AgreementID Inner Join wt_collectors U on U.ID = PA.CollectorID WHERE Month(PA.EntryDate) = Month('2010-11-22') and Year(PA.EntryDate) = Year('2010-11-22') ) V Inner Join wt_collectors U on U.UserName = 'APAY' INNER JOIN wt_Expectation X on X.Experience = U.Experience AND X.Category='Daily' INNER JOIN wt_PerformanceLevel PL on V.Value >= PL.MinPercent * X.Amount Order by PL.MinPercent desc Limit 1 )G
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.