Tallying Up?!?

<i><b>Originally posted by : ami (ames@madcreations.net)</b></i><br /><br />if i have something like this:<br /><br />stuff score<br />-----------------------<br />1 3.0<br />2 5.0<br />1 2.0<br />1 1.0<br />2 3.0<br /><br />how do i add up all the one's and then<br />add up all the two's .. so that it'll <br />come out looking like:<br />------------------------------<br />Total of 1's 6.0<br />Total of 2's 8.0

<i><b>Originally posted by : steve</b></i><br />you could have a stored procedure do the addition on the sql side then pass the results to you and then you just write them out.<br /><br /><br /><br /><br />------------<br />ami at 3/26/2000 8:48:20 PM<br /><br /><br />if i have something like this:<br /><br />stuff score<br />-----------------------<br />1 3.0<br />2 5.0<br />1 2.0<br />1 1.0<br />2 3.0<br /><br />how do i add up all the one's and then<br />add up all the two's .. so that it'll <br />come out looking like:<br />------------------------------<br />Total of 1's 6.0<br />Total of 2's 8.0