Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
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)
|How to find all values in a column which is not money||25||24|
|Troubleshooting Methodology - steps||3||17|
|Pivot not using aggregate yield error||3||13|
|Sql to Replace Folderpath string in MS Access Table field||7||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!