Quote:
quote:Originally posted by Old Pedant
This could be really easy if you know ahead of time that you only care about ID's 1,2,3 in the OptionsMapping table. But assuming that this table is dynamic--that you can add new options in new categories at any time--then it's much much more difficult.
So... ARE the categories FIXED? Or do you need to handle dynamic mappings??
[ Your design for StrengthAndConditioningDaily is also less than ideal for the purposes of this task, but it's at least usable. ]
|
First of all thanks for quickly reply....
So... ARE the categories FIXED? Or do you need to handle dynamic mappings??
No categories are not fixed. I need handle it dynamic mappings.
Here I want result(Output) columns except "Player" and "Total" columns all come dynamically from the OptionsMapping table.
If you are talking about "Cetegory" column of "OptionsMapping" table. It can be fixed if easier to implement T-SQL. Since I am inserting options in "STRENGTHANDCONDITIONINGDAILY" only for one category.But options are not fixed it can be any number for one cetegory.
Thanks a million ton
Developer
Anil Dwivedi