We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
select extract(year from E.EENDDATE) as "Year", (extract(yearday from E.EENDDATE) - extract(weekday from E.EENDDATE-1) + 7) / 7 as "Week", sum(A.AMOUNTCHARGED) as "Value" from CCREVENTS E inner join CCRACC A on (E.CONTRACTNO = A.CONTRACTNO) group by extract(year from E.EENDDATE), (extract(yearday from E.EENDDATE) - extract(weekday from E.EENDDATE-1) + 7) / 7 -- it doesn't like this line having brackets and operators in it!
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|[Unsupported] SQL Update in CRM 2011 Database||19||64|
|Deny sending to more than 2 recipients in Exchange 2016||2||46|
|How to get data off Lotus Notes server||4||69|
|Creating a View from a CTE||15||46|
Join the community of 500,000 technology professionals and ask your questions.