Thank you both for your replies.
Unfortunately I have to be careful what gets posted publicly as I work for a hospital. I am not sure I could get you sample data or post the entire stored procedure without getting myself in trouble. I will run your suggestions by our DBA's and see if they have an idea on how to do this. Thanks for all your help!!
If they come up with a solution I can post, I will.