I am trying to update multiple rows in one table, based on a select ... If you want to update all those records, change the = to IN : UPDATE dbo.
www.google.com.tw