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

BALA SINGAM

, ,


1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

4 responses to "Update top N record in SQL Server"

How to Make Thousands of Dollars Posting Links on Google said:
June 11, 2009

Thanks for posting, I’ll definitely be subscribing to your blog.

Maxim Fateev said:
August 28, 2009

You can just use

update top(100) daily_sails
…
…

BALA SINGAM said:
August 28, 2009

Thanks Maxim Fateev.

Its seems much simpler solution. Thanks for sharing!

Libya said:
October 14, 2009

Thanks for sharing, it was helpful.

Leave a comment

Name : 
Mail : 
Website : 
Message :