Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 2,443 total)

  • RE: Calculate Distance in Miles from Latitude and Longitude

    RBarryYoung (5/21/2009)


    stevewagner (5/21/2009)


    The sample code is wrong.. the function is named LatLonDistance - so replace calculateDistance with LatLonDistance

    Yes, the sample test code has a typo in it. jcrwf02 caught...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    David Benoit (5/21/2009)


    Lynn Pettis (5/21/2009)


    Sorry guys, but I mellowed my post. I checked his profile and he has only been a member of this site for about 6 months....

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Do You Have a Problem?

    rboggess (5/21/2009)


    You forgot something very important that I learned very early on in my career. Sometimes, you just have to sit back and let bad things happen, or now...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Do You Have a Problem?

    blandry (5/21/2009)


    I think the inherent contradiction in your own editorial highlights the biggest problem with DBAs. Quoting your own words...

    "Too often we find people acting as a DBA, even...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: how to retrive the second highest value from the table

    Paul White (5/21/2009)


    Would paying everyone NULL work?

    :w00t:

    No, because NULL is undefined, could be $1, could be $1,000,000,000.00. You'd be bankrupt in a heartbeat :hehe:

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: How to transfer the data from Excel to SQL2005

    If the first row is the header, then put the formula on row 2 and change it accordingly. the column it's adding to the string should be on the same...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: how to retrive the second highest value from the table

    Gianluca Sartori (5/20/2009)


    I can't believe this thread is still alive...

    Maybe we'll have to write an article titled "100 ways to find 2nd highest salary"...:-D

    Fire the 1st guy and find max(salary)...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: How to transfer the data from Excel to SQL2005

    If you're only needing to do this as a one-time shot, you could try what those of us without any real rights do.

    In Excel, (I'm pretending your data is...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Gail, don't know if you saw this thread, Gianluca is looking for some clarification on short-circuiting in OR statements. Looks like they've done some testing on their own, but aren't...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    tosscrosby (5/15/2009)


    Lynn Pettis (5/14/2009)


    The sun has set in the deep desert and lone figure sits quietly meditating next to a small camp fire. While sitting there, he simply cannot...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    RBarryYoung (5/14/2009)


    Paul White (5/14/2009)


    Bob Hovious (5/14/2009)


    Hey Bruce and Paul... how is life in New Zealand? Where do you each live again? Bruce, you're on the North...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    GilaMonster (5/11/2009)


    Gaby Abed (5/11/2009)


    Ahhh...those were the days, I actually had an Enterprise technical manual and briefly had in my posession the Klingon/English dictionary.

    But not anymore... (<-- he adds hastily) ...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    David Burrows (5/5/2009)


    Child - "But Dad, that isn't how they taught us to do that at school!"

    Dad - "Did I get the right answer?"

    Child - "Yes, but that isn't how...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Advise for complete Beginners

    jennifer_l_hogan (5/6/2009)


    ... starting point is knowing access, which is much easier to learn than SQL.

    hmm, sort of. Until you get to that whole "Why doesn't this make sense?"...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Original Theatrical Release of Star Wars

    Dave Smith (4/30/2009)


    I saw it with my parents at the Meadows Center Cinema duplex in Terre Haute, IN, USA.

    I was 6 years old.

    It took a few days to get my...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 15 posts - 2,056 through 2,070 (of 2,443 total)