This is a bit extreme, but if you want to 'go all the way' in moving business logic out of your stored procedures, this explains one way of going about it:
http://www.codeproject.com/gen/design/DudeWheresMyBusinessLogic.asp