I have a table that holds results. Based on what the
ResultTypeId is these could be either
INT. In order to handle all these types the
Value field is
I've found that when handling the results I get problems. For example when trying to sum multiple
FLOAT results I need to cast them to
I think this is the wrong approach to storing the data. The only alternative I can think of is to create a value field for each data type, e.g.:
What is the recommended approach for this problem?