I am returning a list of machines to a gridview by rental packageID, the the rental packageID shows a rental amount in a new column.
Rental Package ID Annual Rental
The problem is that for any machine where the rental packageID is the same as another, the annual rental shows the value twice, this is a problem as the footer in the griview calculates the total of the column and its bringing incorrect values.
Does anyone know how to fix this is my stored procedure?
View Complete Post