stored procedure

[Guest_imported]

Hello,

would you please help me how to get percentage breakdown from field?

example:

I have the table named "complaints".How to write stored procedure to get percentage berakdown of complaints by Category(taxis, moving companies, towing companies, others)??

Thank you very much for your kind help.

 

[foxdev]

[tt]declare @nTotalRecs int
select @nTotalRecs = count(*) from Complaints

select Category,
count(Category)*100/@nTotalRecs as Percentage
from Complaints
group by Category [/tt]

I haven't tested this, but I think its close. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com