Calulate percentage on a count of a column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Calulate percentage on a count of a column

Author

Topic

Mario Noronha
Starting Member

6 Posts

Posted - 2010-06-30 : 06:20:38

hi this is my query

select distinct CONVERT(VARCHAR(10),LastChangedON_UTC,101) as Date,LOB,
count(ApplicationOwnerConfirmation) as VlidatedCount
from dtp_p2.InventoryMainExport
where ApplicationOwnerConfirmation ='Validated'
and CONVERT(VARCHAR(10),LastChangedON_UTC,101) in
(select distinct CONVERT(VARCHAR(10),LastChangedON_UTC,101) as CAT from dtp_p2.InventoryMainExport)
Group By LOB,CONVERT(VARCHAR(10),LastChangedON_UTC,101) order by LOB asc

now i want to calculate the percentage on the following
count(ApplicationOwnerConfirmation) as VlidatedCount

can any once please help

Thanks
Mario Noronha

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources