Hassle-free live chat software re-imagined for business growth. 2 users, always free.
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
|Calculate values in an array||18||33|
|object oriented programming comparison||5||52|
|Could you possibly give a help on how to configure Datatables plugin to make it correctly runs?||5||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!