scott.pletcher (6/11/2010)

---

>> but when you post junior level code (non-SARG-able queries anyone?) <<

Yes, I took the short-cut, because as *I* pointed out the code will result in full scan anyway.

When...

If you only have 3 months in your db per person at a time, then the following should work

SELECT Person,

CASE MonthTot

WHEN 6 THEN 1

WHEN 9 THEN 2

WHEN 12 THEN 3

WHEN...

I worked for a company that had a subscription to Experts Exchange and it was rare that I'd find any worthwhile answers there. Even rarer that I'd find an answer...

UMG Developer (6/11/2010)

---

My initial reaction was that it would return one row, but I thought this is too easy for a question worth 3 points. So I looked a little...

So will future "questions of the day" just be proofreading? Find the misspelled word! I think of questions of the day as testing knowledge of concepts, not spellchecks. I know...

Richard Gardner-291039 (6/10/2010)

---

There's no antagonism, just call football football and gay rugby gay rubgy (or hand egg), that's not a lot to ask, I think, it is logically consistent after...

Richard Gardner-291039 (6/10/2010)

---

Football doesn't need a new name, it has one, and has had since it was invented, giving it a new one because you've hijacked it for handegg (or...

Richard Gardner-291039 (6/10/2010)

---

Oh, you're talking about Hand Egg? I thought you were talking about Football....

http://www.dailyhaha.com/_pics/hand_egg.jpg

I would recommend you actually start watching the football, the USA actually have more than a...

GilaMonster (6/9/2010)

---

Stefan Krzywicki (6/9/2010)

---

Not that I can see. Base on the limited and incomplete information being provided, it does seem as if he or...

Krasavita (6/9/2010)

---

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Base_CatalogHP". The conflict occurred in database "database1", table "dbo.Base_table1", column 'id'.".

I get this error. I am trying to copy table...

Not that I can see. Base on the limited and incomplete information being provided, it does seem as if he or she is getting...

CirquedeSQLeil (6/9/2010)

---

Stefan Krzywicki (6/9/2010)

---

CirquedeSQLeil (6/9/2010)

---

Stefan Krzywicki (6/9/2010)

---

As a Packers fan, I'm fine with him right where he is.

Ship him to Green...

I would suggest explicity stating each column you want to return in the query even if you want to return all 20. Using * is sloppy and can give you...

CirquedeSQLeil (6/9/2010)

---

Stefan Krzywicki (6/9/2010)

---

As a Packers fan, I'm fine with him right where he is.

Ship him to Green bay or Minnesota...

As a Packers fan, I'm fine with him right where he is.

Steve Jones - Editor (6/9/2010)

---

I just can't see women playing...