Results 1 to 1 of 1

Thread: Can someone tell me what is wrong with this statement?

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2001
    Location
    Houston, TX
    Posts
    342

    Can someone tell me what is wrong with this statement?

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

    Thanks!!
    Last edited by MagellanTX; Oct 10th, 2001 at 11:05 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width