Dan, Jeff, Rudy, 20 seconds? That seems a little long for a simple query like this one. Are the indexes correct? Like jeff said, a store procedure may speed up things, but I assure you the majority of the 20 seconds is not plan creation, which is the only thing you'll save by having this query in a stored procedure in this case. This query is not really complex. There may be a lot of data, but 20 seconds?! There is something else going on to slow down the query that much. -joshua > also , the front page query is taking like 20 seconds to run.. can we > make a view out of this:?