I have 5 columns in a database with a value
and 5 matching bit columns
I need to sum up the values in val1 only when Valbit1 is true Val2 when Val2 is true etc etc
all returning 1 summed value
I need to do this is a stored procedure not sure how to proceed?