Ninja's_RGR'us (1/7/2010)

---

Are those times in seconds or is it another figure?

If it's seconds and assuming that query won't run 100 times a second, then there's no real need to tune...

I must appologize MarkO. As I said before, I'm not SQL expert. I had thought that the select statement in the "if" would cause your method to be...

The goal was to try to speed up the process by eliminating an extra query. I'm no expert on SQL, but I would think that combining into a...

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...