Update on 80% of Records - WebDeveloper.com

		WebDeveloper.com > Server-Side Development > SQL
Update on 80% of Records

SQL For all Structured Query Language, and general database questions.

11-06-2009, 01:43 PM

ssystems

Registered User

Join Date: Oct 2009

Posts: 232

Ugggh. Don't you think its time to upgrade?

Here is on MSSQL

Code:

update comments set marker = 'foo' where id in (select top (FLOOR(4 * (SELECT COUNT(*) FROM comments ) / 5)) id from comments ORDER BY NEWID())

I think you can do something similar to that in 5.0.7 using Prepare. Check the concept and just translate it to the syntax of your database.

__________________
Good Luck

Santos Systems

Bookmarks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

All times are GMT -5. The time now is 08:38 AM.