have a problem and hope to seek some help and advices.
i have a database which have field names
Date|time|data
the situation is i have time in every half hour interval..
DATE|TIME|NUMBER
02/05|11:00|4
02/05|11:30|5
02/05|12:00|6
02/05|12:30|5
i want to add row time 11:00 and 11:30 @ column NUMBEr together , 12:00 and 12:30 @ column number and so on. after this addition, find the max of the sum value and display.
so for e.g for 11:00 and 11:30 the outcome is 9 then compare wif 12:00 and 12:30 the outcome is 11.. comparing 9 and 11, the max is 11. display in datagrid.
are there any reference or sample codes for reference?
help is greatly appreciated!!
i have a database which have field names
Date|time|data
the situation is i have time in every half hour interval..
DATE|TIME|NUMBER
02/05|11:00|4
02/05|11:30|5
02/05|12:00|6
02/05|12:30|5
i want to add row time 11:00 and 11:30 @ column NUMBEr together , 12:00 and 12:30 @ column number and so on. after this addition, find the max of the sum value and display.
so for e.g for 11:00 and 11:30 the outcome is 9 then compare wif 12:00 and 12:30 the outcome is 11.. comparing 9 and 11, the max is 11. display in datagrid.
are there any reference or sample codes for reference?
help is greatly appreciated!!