Update top N record in SQL Server
June 9, 2009 4 Comments
Disclaimer : This tutorial is meant for beginners and for anyone who find it useful. The main purpose of this post to keep everything i find useful for future reference for myself and for others.
SQL statement to update top N records
update daily_sales set is_calc='Y' from daily_sales inner join (select top 100 * from daily_sales where product_category='CA') a on a.unique_record_id=daily_sales.unique_record_id and a.milestone_code=daily_sales.milestone_code
Source is SQLServerCentral