Float VS Decimal for storing percentages in SQL 2005
I see that some people use float to store percentages and some use decimal. When storing percenatges in a table what are the pros and cons of each? Is one method better? Is decimal better because it is an exact number?