I’ll keep this as brief as possible,
I have the following columns in my database: fun1, fun2, skill1, skill2, day1, day2, showcase
The respective fields in the columns above are populated by an integer. I want to copy the first and second integers over zero that appear in the above columns into two columns: camp, camp2.
If there are any remaining integers over zero a new row is created and those integers are stored in camp, camp2 within that new row.
Here is an example:
| fun1 | fun2 | skill1 | skill2 | day1 | day2 | showcase | camp | camp2 |
| 0 | 25 | 0 | 0 | 30 | 15 | 0 | 25 | 30 |
| 15 |
I want to know the best method to achieve this, right now all I can think of is a long and treacherous tree of “if” and “else” statements. This just seems impractical, any assistance would be greatly appreciated!
Thank you