Update First row in the table

[Leong]

Hi

I have master and detail table. In master table I have one record and detail table I have more than 1 record for each invoice. I want to update first row in my detail table for each invoice. Is there any way I can update only first row for particular invoice. For ex. In T-SQL we can use "Select top 1 from tablename". Is there similar command to update 1 row in table. Thanks in advance

Regards
Leong

[Dale Shaw]

Hi

You would have to perform the update based on Primary Key value of the selected record.

UPDATE InvoiceDetails
SET Something=1
WHERE InvoiceDetailID=
(
SELECT TOP 1 InvoiceDetailID
FROM InvoiceDetails
WHERE InvoiceID=1234
)

Dale