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 2000 Forums
 SQL Server Development (2000)
 Count Percentage

Author  Topic 

Steve2106
Posting Yak Master

183 Posts

Posted - 2010-07-06 : 11:25:05
Hi There,

I have a table with 2 columns.
1. Source 2. Percentage

I need to get the percentages of the source. The percentage column has values like 0, 10, 30, 40 etc for each record.

so there could be source "Safety" and I need to say 0% = 23, 10% = 9, 20% = 22 ... 100% = 41

Whats the best way to do that?

Thanks for your help.

Best Regards,

Steve
   

- Advertisement -