Forum Replies Created

Viewing 15 posts - 16 through 30 (of 34 total)

  • RE: Calculate Distance in Miles from Latitude and Longitude

    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 -...

  • RE: Calculate Distance in Miles from Latitude and Longitude

    @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...

  • RE: Calculate Distance in Miles from Latitude and Longitude

    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...

  • RE: Length

    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...

  • RE: Foreign Keys

    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...

  • RE: An Introduction to Database Design

    Jeff Moden (3/29/2011)


    In the presence of the element "Administratium", it's all for naught, anyway. 😉

    Is that anything like the Illuminati??

  • RE: Count Distinct

    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...

  • RE: An Introduction to Database Design

    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...

  • RE: Getting Started in SQL Server

    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...

  • RE: Inception

    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...

  • RE: Inception

    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)....

  • RE: SELECT setter

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

  • RE: Declarative Data Integrity

    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,...

  • RE: Database Size

    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...

  • RE: How long is a NULL?

    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...

Viewing 15 posts - 16 through 30 (of 34 total)