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 procedure is trying to use its value on the second stored proc.  Just a guess.

---

Sincerely,

Carl
-----
vine type - content management with standards in mind - vinetype.com
-----