Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
select count(*) as Total, ST.ApplicationType, cast(((count(*) * 100.0) / 741) as DECIMAL(10,2)) as Percentage from AppRepository AP left join SourceType ST on AP.applicationType = ST.SourceID where AP.Retired = 0 group by AP.ApplicationType, ST.ApplicationType
Total ApplicationType Percentage 5 Access 0.67 21 Client 2.83 1 Crystal Reports 0.13 303 Distributed 40.89 25 Distributed/Mainframe 3.37 1 Function 0.13 242 Mainframe 32.66 1 Other 0.13 24 Web - External/Distributed 3.24 76 Web - Internal/Distributed 10.26 41 Web - Internal/External - Distributed 5.53 1 Web - Internal/Mainframe 0.13
|SQL Select Query help||3||31|
|How to retrieve data related to last id inserted into database||3||24|
|How to place a condition in a filter criteria in t-sql (#2)?||10||19|
|How to Install SSIS without the SQL Server CD||3||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!