I am trying to write a stored procedure to update a temporary table. In my table are some isbn's that are in twice. I want to update those rows with a new value, but can't see how to do it without a cursor checking each row to see if it matches the previous isbn. Is there a better way? I know it doesn't work, but it would be nice if I could do something like;
SET source = 'Mixed'
WHERE Count(isbn) > 1
Thanks in Advance for any help,