Melanie, This one seems pretty tough from your description, but if this is any help at all ---  it's been my experience that when a stored procedure is working for a while and then stops working that the problem is in the database not the stored procedure.   Perhaps somehow a NULL has worked its way into a table and the stored ...