Update x Rows not working

[ino_mart]

All

I use next SQL-command in MS SQL 2008 to update the top 1 record of my table. However, all records with FK=826 and status='' are updated.

update tblO set Status='In', Oms='20331266' where fk in (select top 1 fk from tblO where status='' and fk=826)

Does someone have a solution?


Regards
Ino

 

[ino_mart]

I found the solution. Seems it is as simple as

update top(1) tblO set Status='In', Oms='20332055' where status='' and fk=826