存储过程更新所有行而不仅仅是单行

I have a stored procedure that for some reason works except it is updating ALL rows within the table and not limiting to the unique identifier - can anyone suggest why?I have a stored procedure that for some reason