• I believe you are correct.

    The only way to do this is:

    DELETE Customer

    WHERE CustomerId IN

    (

    SELECT TOP 10 CustomerId

    FROM Customer

    ORDER BY DateAdded DESC

    )

    I'm not sure what DELETE FROM (SELECT TOP 10) does, but I wouldn't trust it without correlation, personally.

    --
    Adam Machanic
    whoisactive