Thanks everyone for the suggestions. I also appoligize about the limited information. Its hard to post the real code because of my company and because its so large.
I will say yes it helped! Went from 5 seconds down to 1 second on my little db for run time.
***SQL born on date Spring 2013:-)