This data will be used in a SQL Server Reporting Services report. The value will be calculated to a display a percentage in the report, so the trailing zeros are fine. I...
I think I have found the answer. I'm going to populate my table with only the distinct match condition fields with also an ID field using the IDENTITY property....