Is it possible to do the following in one statement:

SELECT ID
INTO #ProcessList
 FROM MyTable
 WHERE Processed = 0

 UPDATE MyTable
 SET  Processed = 1
 WHERE FeedID IN ( SELECT ID
      FROM #ProcessList )

 SELECT ID #ProcessList

 DROP TABLE #ProcessList

TIA

MattC

Using the OUTPUT direction in SQL Server 2005

UPDATE MyTable
SET  Processed = 1
OUTPUT INSERTED.FeedID AS ID
WHERE FeedID IN ( SELECT ID FROM MyTable WHERE Processed = 0)

-----------------------------------------------Reply-----------------------------------------------