EXEC UPDATE_STATUS NC_UNIQUEIDThat parameter value needs to either be an integer or a integer typed variable. that is why you're getting the error. but in any case you need to be able to deal with multiple values being updated in a single statement.