figured it out from stackoverflow

WITH CTE AS (SELECT TOP (1) * FROM T_VM_QUEUE WHERE STATUS_CD = 'P' AND Dialer_Tbl_Nme = '5010_5010' ORDER BY ImportRuleDate ASC) UPDATE CTE SET STATUS_CD = 'S'