Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
SELECT DATENAME(mm,FilteredNew_application.new_effectivestartdate) as Month ,sum(FilteredNew_application.new_gp) as GP ,sum(FilteredNew_application.new_approvalamount) as Approval ,sum(FilteredNew_application.new_equiptmentcost) as Revenue FROM FilteredNew_application WHERE FilteredNew_application.new_primaryvendoridname LIKE N'Dell%' AND FilteredNew_application.new_applicationstatusname = N'Vendors Paid' AND FilteredNew_application.new_effectivestartdate >= N'02/01/2010 00:00:00' Group by DATENAME(mm,FilteredNew_application.new_effectivestartdate) Order by DATENAME(mm,FilteredNew_application.new_effectivestartdate)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|What is this datetime?||1||28|
|SQL Query incorrect syntax near the keyword ON any help would be appreciated||18||30|
|Email based on ssrs data set email||2||11|
|SSRS 2008 Jump To Report||4||24|