I am trying to update only the first 10 rows of a table. I am using the statement:
However, when this runs it updates all the rows in the table. What am I doing wrong?Code:UPDATE Incoming
SET ID='2'
FROM (SELECT Top 10 * FROM Incoming) AS t1
WHERE t1.ID='1'
Thanks!!
