Posted by Khan on 03/25/06 09:20

I'm using where condition e.g. " where assign = ' ' ". but this
condition is true for 100 rows, and i want to update only first 15
rows, otherwise all 100 rows will be updated which i don't want.
I tried SET ROWCOUNT but coud'nt get through.

• Next in forum: Re: Query/View: The 2 newest periods for each indicator
• Prev in forum: SQL Server 2000 for sale
• Thread view: Re: Update n rows

[Reply to this message]