Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!