Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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)
|SSRS ReportViewer report timeout||7||105|
|SSRS -- hover over value OR column in grid report to display vaule||12||22|
|Sql Query Datatype||2||19|
|Using SQL Server 2008, how would you convert [datediff(day, dtcreated,getdate()) AS Age] into its equivalent if "dtcreated" is defined as varchar(10)?||14||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
29 Experts available now in Live!