scott.bernstein (4/15/2011)

---

I believe you are computing the length of arc on the surface of a sphere - which is cool... But the earth is not a perfect sphere -...

@jcrawf02: I'm not sure that's what Caruncle wants, but I thought I would just post a tangential use for such a function. I use it for determining location...

For US developers, this would be helpful in combination with a dataset of zip codes and their lat/long coordinates (this is one I've found useful: http://federalgovernmentzipcodes.us/).

Additionally, you could adjust...

Scott Arendt (4/8/2011)

---

tilew (4/7/2011)

---

What I don't understand, is why SQL told me that the lenght is 4, but microsoft says "the storage size, in bytes, is two times the number...

Sean Lange (4/5/2011)

---

I didn't even really read the create table statements. I saw the insert at the bottom with a StudentID, skimmed up and saw it referenced the students table...

Is that anything like the Illuminati??

I got it right by eliminating the answers which were wrong. Incidentally, maybe this is something specific with SSRS (which I have no experience with), but my initial instinct was...

I took a "Fundamentals of Database Design" class last semester (for credit only; it was insulting since I am pretty well-versed in fundamental DB design already through self-training). And you...

This was an excellent article! I even forwarded it on to the manager of a company who was asking me for help in determining what sort of skill requirements someone...

TravisDBA (8/6/2010)

---

Q: "What do you think of the new iPhone 4?"

Brain processes: iPhone 4 -> AT&T -> Poor reception -> My brother's reception is next week -> The Expendables...

Inception is an excellent movie, although not quite as mind-blowing as I was expecting (it delves into similar material that Dark City, The Matrix, eXistenZ, and Mulholland Drive all do)....

GAH! I don't really know what I was thinking when I answered. Obvious answer, but I obviously got it wrong. *grumble*

Oops, I misread the last statement as a join on the first table, not the second one. It makes sense now. Staring at SQL all day messes with your head,...

Ambiguity perhaps ... but in this instance, I actually got it right! I guess I happen to fall into that realm of a 2MB/1MB database when I create a new...

Interesting behavior ... I had to look up the YIELDS_NULL ON before I answered the question, then still got it wrong. Had I thought about it longer, I would have...