I have a question on a query...Im trying to update a value from a table, but it should only update top 1. Here's my query:
UPDATE T_VM_QUEUE SET STATUS_CD = 'P' WHERE STATUS_CD = (SELECT TOP (1) STATUS_CD FROM T_VM_QUEUE WHERE Dialer_Tbl_Nme = '5010_5010' ORDER BY ImportRuleDate ASC)
Instead of updating Top 1, it updates all the records. What the heck am I doing wrong?