WayneS (1/28/2011)

---

Tom.Thomson (1/28/2011)

---

edit: I missed a whole page of comments - must have skipped accidentally from page 1 direct to page 3 without passing page 2 and without collecting essential...

Carla Wilson-484785 (12/2/2008)

---

AND not too long ago, there was a forum post about trailing blanks in nvarchar, and how that can be a problem in comparisons, etc. unless you use...

Frank Kalis, article

---

Updateable views are not always possible. For example there is a problem when a view addresses only that part of a table that includes no candidate key. This...

GilaMonster (1/28/2011)

---

Tom.Thomson (1/28/2011)

---

I've added another response. Maybe I'm going crazy, but to me you both seem to have missed the fact that he's trying to pass a large number...

wolfkillj (1/28/2011)

---

I think the "P" in STDEVP does stand for "population", as that function returns the actual standard deviation of the entire population (sometimes called the "n" method); hence, the...

WayneS (1/28/2011)

---

Your wish is my command 😀 ... he's been guided to a suitable split function.

Edit: and you were...

You can't get more than 1 case number into a 12 character field. That really would be magic! You need to change that parameter type (maybe change its...

An alternative to PITB.

Well I got this one wrong, mainly because the SQL function naming is a little bizarre:

STDEV is the estimated Population Standard Deviation (although there's no P in the...

Thanks for the question.

MS terminology is sometimes somewhat bizarre, isn't it! 😀

I started looking at this topic again because it was flagged as having new material I hadn't seen before. I don't know why it was flagged like that, because...

David Portas (1/22/2010)

---

Irrespective of that, the Normal Forms, upto and including 6NF don't leave any room for the possibility of nulls. Codd himself says so: "The concepts and rules of...

David Portas (1/22/2010)

---

PaulB-TheOneAndOnly (1/21/2010)

---

All the conventional Normal...

sjsubscribe (1/20/2010)

---

Certainly the current practice is mixed at best or else no DBMS would allow null values as valid entries in a field. That's what the relational theory purists wants....

Chrissy321 (1/26/2011)

---

Putting aside ISNUMERIC and its issues I still don't understand why a CONVERT would work when selecting a field but not in the WHERE clause.

Is it possible that the...