So, for someone who is using 2000 still, but looking forward to 2005, EXCEPT will let me intersect the two sets, and give me the results that are not overlapping,...

What's orange and sounds like a parrot?

No no no, you SEE color, you don't spell it.

humbleDBA (7/11/2008)

---

CAGreensfelder (7/10/2008)

---

I give - what's it mean?

The first sentence looks like "Be unwilling to arrogantly...

Just curious, since I used something similar to your previous business day example in-house for a call center: When calculating your business time, how are you handling down-time? (or...

bnarav (7/16/2008)

---

I need to check the number of rows in a result set returned by a query in execute SQL task and execute different tasks based on the number of...

I agree with both of you, and am about to spout something crazy - every part of the business affects every other part of the business.

I know! what...

Lynn Pettis (6/30/2008)

---

Peter,

I just took the time to read your article above. I wish I had know about it as I was doing my article, I would have...

Loner (6/26/2008)

---

Actually in both cases all the database development were done by web developers. The management just wanted to get the project done within the deadline and it was...

Nah... "Must look eye!"... Sergiy doesn't need to know about all of that... he's trying to get you to go look back at your code to see why you don't...

I have three...

Jeff Moden (6/27/2008)

---

I don't see where you've used that particular ISNULL as a join. It think it would be a problem if it were actually in a join because...

Thanks, I've seen you post that before, but never saved it (until now). 16 seconds (first run) on my system.

So, is the JOIN on ISNULL ok? Or is that...

Ian Crandell (6/26/2008)

---

Matt - Have you worked in government? When I was in the Air Force,...

Don't know if you've made your decision yet, but I'd say pick the title that keeps the most of what you like doing, and leaves you career path opportunities, chances...