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
<cfquery name="qCurrYear" datasource="#application.datasource#" cachedwithin="#CreateTimeSpan(0,0,5,0)#"> SELECT ClosingDate, YEAR(ClosingDate) as theY, MONTH(ClosingDate) as theM, ClosingID, ListingId, Commission, Bonus, ReferralPaid FROM closings WHERE year(ClosingDate) = #currentYear# <!--- CURRENT YEAR ---> </cfquery> /////////////2nd Query referencing the master query (above)//////////////////////// <cfloop from="1" to="12" index="m"> <cfquery name="MoComCur#Left(MonthAsString(m), 3)#" dbtype="query"> SELECT ClosingDate, sum(Commission) as TotComish, sum(Bonus) as TotBonus, sum(ReferralPaid) as TotReferral FROM qCurrYear WHERE month(ClosingDate) = #m# AND year(ClosingDate) = #currentYear# group by month(ClosingDate), year(ClosingDate) </cfquery> </cfloop>
|Visual Studio only works when connected to my office's network.||8||99|
|Best way to get started with a small Responsive website||5||134|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!