I think the use of the term "ignores" is not semantically correct (even if it used by BOL). "Excludes" is more accurate.

1 + 2 + 3 + NULL...

stevefromOZ (12/30/2014)

---

In a way, some of the answer depends on the delivery mechanism you're going to use and the experience level of your user base.

SSAS - much more than just...

MMartin1 (12/31/2014)

---

How would this be different? Would you have fields in the table to denote first Tuesday of the...

Pats, Pats, Pats.

Brady's going to carve up secondaries like a holiday turkey.

Or build a calendar table and use it in a dataset.

7

You have to go 3 - 3 in your division, as does the rest of the division and all teams in the division go 0 - 10 in the other...

Jeff Moden (2/28/2013)

---

I think the most important part of the article has been overlooked by those rightfully aghast at yet another seemingly “interview question” article. Here’s the quote. ...

So, fundamentally what is being said (or acknowledged) is that this is NOT a table of phone numbers. It is actually a bunchO'stuff table that may contain phone numbers....

CELKO (12/19/2014)

---

Build a calendar table with one column for the calendar data and other columns to show whatever your business needs in the way of temporal information. Do not try...

Um, yeah. It won't kill you to use a butter...

Interesting that the text 'false' evaluates to 0. I would have guessed that any non-empty string would evaluate to 1.

Eric M Russell (12/17/2014)

---

DonlSimpson (12/17/2014)

---

spaghettidba (12/16/2014)

---

Use 0 if the value exists and it is 0.

Use NULL if the value does not exist or is undefined.

If you used 0 when NULL...

spaghettidba (12/16/2014)

---

Use 0 if the value exists and it is 0.

Use NULL if the value does not exist or is undefined.

If you used 0 when NULL was more appropriate, how...

MMartin1 (12/16/2014)

---

It would not, but that is what the user wanted. That is to prevent...

I'd be really hesitant to default a "1" into a calculation like this....