Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
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!
|Help with SQL field formatting||3||20|
|query logins with details regarding database users and privilege level||4||35|
|Exchange 2016 Databse move||5||28|
|What logic to build in order to get a weekly reminder||9||42|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!