There was a good thread on the SqlAdvice.com Stored Procedure list today which included several solutions for this problem. The latest and ostensibly best one so far can be found in the sql archives here. That list, and the other lists on SqlAdvice, are great places to ask questions about anything database and SQL related.
