Thanks for the responses, but in each of those, wouldn't it still be running two queries and just return a single data set? I was hoping to figure out...
Thanks alot Seth. I got looking deeper and realized the server I'm working on isn't 2005 after all, it's 2000sp3! I've got so many servers here to deal...