Date: 08/04/07 (SQL Server)    Keywords: web

I am making a project intranet page and I need to pull up a section of tasks that have been completed in the last week and currently have it only pulling the last 10 items on the webpage with the following code, any more efficient suggestions?

SELECT *
FROM tasks
WHERE complete = 'y' AND
comp_date < current_timestamp

Source: http://community.livejournal.com/sqlserver/62020.html