Jeff Moden (9/30/2010)

---

Jack Corbett (9/30/2010)

---

Update on the "maverick". Just had discussion with my boss about it. I've been asked to write up an email about what has been...

Roy Ernest (9/30/2010)

---

Jack Corbett (9/30/2010)

---

Roy Ernest (9/30/2010)

---

On another note, who all are going for the pass summit and who all will be going for SSC Party?

I will be there for...

Update on the "maverick". Just had discussion with my boss about it. I've been asked to write up an email about what has been going on to "document"...

Gianluca Sartori (9/30/2010)

---

Totally different topic: how big was the biggest SQL statement you had to deal with?

This is a statement generated by our BI front-end.

Surprisingly enough, after 4 minutes of...

Great....

GilaMonster (9/29/2010)

---

Kit G (9/29/2010)

---

Because a woman couldn't possibly be wrong and therefore whatever she came up with would work and wouldn't...

Brandie Tarvin (9/29/2010)

---

Do you have any control over, or input into, this person's projects?

If so, I'd...

Thanks for your thoughts on the "maverick" coder. Unfortunately I don't have the authority to remove the person or force conformity. I have brought up the issue a...

So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off and does things however...

Grant Fritchey (9/29/2010)

---

Stefan Krzywicki (9/29/2010)

---

Oh, I think there's a point to meetings. If you're all working on the same thing and are talking about problems so everyone can think about...

Stefan Krzywicki (9/29/2010)

---

GilaMonster (9/29/2010)

---

Right now I'm feeling the pain of project managers rather than BAs

Got a project manager that holds a weekly meeting in which does the following:

* Asks the...

I'd love to have the opportunity to work somewhere where there is a BA and a PM and where I wasn't everything. Then at least I could complain about...

CirquedeSQLeil (9/23/2010)

---

Lynn Pettis (9/23/2010)

---

Okay Tom and Bob, I think that is enough. Just agree to disagree and let's move on.

And no, I'm not going to check out the link...

Sounds a bit like Nitrosphere. Check that out.

All your variables are defined as INT which means you are getting all INT values . This:

(ISNULL(@vperc,0)/100)

will return a 0 for any @vperc values that are below 100 because...