If you take the assignment off - you'll see that you're getting the counts within each group that adds up to 7, not the count of the groups. Meaning...

This is one of those cases where CLR would likely be substantially more efficient than the loop. First - you could leverage the "Proper Case" syntax, so that you...

In its most basic form - an audit log is likely to be your best bet. It would capture all of the changes so that you could have a...

You don't want my phone number - it would have to come with a request for your billing info:).

I kind of get the idea, but can you mock up...

bdragoo (3/31/2008)

---

Our server (roughly 300G) had been backing up and sending backup files to an external hard drive connected via a USB 2.0 cable. Needing a more secure and reliable...

GSquared (3/31/2008)

---

Don't use autoshrink. It's a...

Matt Miller (3/29/2008)

---

rbarryyoung (3/29/2008)

---

Thanks, Jeff.

rbarryyoung (3/29/2008)

---

It is one of the hallmark proofs of computer science that you cannot write a program that can generally predict when other computer programs will...

What do you plan on doing with this? What kind of file are you going up against? Is the file structure consistent (meaning - same layout for each...

bhovious (3/31/2008)

---

I was glad to see you qualify your preference for electric-only by recognizing that it only moves the pollution problem to the power grid. If we...

If you're trying to make sure that they don't re-enter existing clients - why not force them to go through the existing list of customers FIRST? Like - a...

Jeff Moden (3/29/2008)

---

Well said. I especially like the two rules because, if you substitute the word "RBAR" for "Cursor", I use them all the time in a slightly different...

While I agree with Jeff on the "having a degree to GET a job" wasn't all that important, I can say that I have been on the receiving end of...

I see you two have been busy... nice testing!

rbarryyoung (3/29/2008)

---

Thanks, Jeff.

rbarryyoung (3/29/2008)

---

It is one of the hallmark proofs of computer science that you cannot write a program that can generally predict when other computer programs will halt (that's...

Jeff Moden (3/28/2008)

---

Mike C (3/28/2008)

---

Jeff Moden (3/28/2008)

---

Mike C (3/28/2008)

---

I get a clustered index scan when I run your code. The optimizer expands it out to RowNum <> 1 AND RowNum...