Subject | calculate difficulty level |
---|---|

Author | Alejandro Garcia |

Post date | 2010-08-10T14:33:49Z |

Good afternoon,

I'm trying to calculate the difficulty level of some exercises, each exercise is identified by a numeric id and the difficulty level is defined by its parameters, each exercise has a different number of parameters.

To calculate the difficulty level for each exercise we identify all the possible values that each parameter can take, those values are given to us in a specific (and correct) order in a table, and we assign a numeric value starting from 1 to each one of it, for example if the values of parameter p are p1,p2 and p3 we have to assign a number from 1 to each of them:

p1=1

p2=2

p3=3

Once assigned this values to each parameter, the difficulty level of the exercise is the sum of the values of every parameter.

Given an execution of the i exercise in a table:

Id Parameters Values

i p p2

i q q3

i r r1

the three lines above should be replaced by one line

Id Difficultylevel

i 2+3+1

I'm trying with a stored procedure, but can't manage..

Thanks a lot.

[Non-text portions of this message have been removed]

I'm trying to calculate the difficulty level of some exercises, each exercise is identified by a numeric id and the difficulty level is defined by its parameters, each exercise has a different number of parameters.

To calculate the difficulty level for each exercise we identify all the possible values that each parameter can take, those values are given to us in a specific (and correct) order in a table, and we assign a numeric value starting from 1 to each one of it, for example if the values of parameter p are p1,p2 and p3 we have to assign a number from 1 to each of them:

p1=1

p2=2

p3=3

Once assigned this values to each parameter, the difficulty level of the exercise is the sum of the values of every parameter.

Given an execution of the i exercise in a table:

Id Parameters Values

i p p2

i q q3

i r r1

the three lines above should be replaced by one line

Id Difficultylevel

i 2+3+1

I'm trying with a stored procedure, but can't manage..

Thanks a lot.

[Non-text portions of this message have been removed]