I have percentages I want to use in SQL Server. The format I want is ##.#, so example numbers are...
10 (or 10.0)
100 (or 100.0)
The numbers will be positive, never more than 1 decimal is needed, and the number will always between 0 and 100.
What is my best datatype to use for such numbers? I could use a smallint, and multiply by 100 to get the precision I want. Or do I want to use a float, real, decimal, numeric, etc? Obviously I want to use as few bytes as possible and have this data still fully storable, and functioning as numbers.