Posted: Mon Jan 16, 2006 1:00 am
ok if I have this query in mssql to get the result I want how do I use it to make an update with out doing each update individually.
Code: Select all
SELECT id, url FROM (
SELECT TOP ($x) id, url FROM (
SELECT TOP ($x) id, url FROM $table WHERE (done = 0) ORDER BY id) AS newtbl ORDER BY id DESC) AS newtbl2 ORDER BY id