cstokes91, I've seen it all too, I'm still new to SQL (as you can tell) but I was thrown in rather at the deep end with a DB I inherited, and there are many columns that should have been of data types they aren't, including int's that were varchars. :)
I feel your pain man... I graduated from college Spring 2012 with a degree in Management Info Systems and once you actually start getting into this stuff it is a whole different world.
My specific job is especially challenging because I do data transfers from clients data to our system so not only do I have to fully know how our system works but I am constantly learning other people's system to get their data over. I hear it gets easier but I haven't seen it yet ;)