Forum Replies Created

Viewing 15 posts - 436 through 450 (of 820 total)

  • RE: Hidden RBAR: Triangular Joins

    I guess that I got bit by the standards bug. The other day I wrote a check to our food delivery driver. He claimed that I fouled up...

  • RE: Slack SQL Server

    Jeff Moden (1/23/2009)


    Another set of useful functions would be some good ol' Lat/Lon functions for calculating great circle distances between two points using Lat/Lon.

    Oh cool! Then I could use...

  • RE: Hidden RBAR: Triangular Joins

    TheSQLGuru (1/22/2009)


    No, he said and meant getdate() because this is a MICROSOFT SQL SERVER ONLY FORUM!

    That's why my FoxPro can't Access the Oracle. How can I make any Progress...

  • RE: Hidden RBAR: Triangular Joins

    Ah! Much clearer. Yet the contention of some is that you are teaching them to ride a better horse rather than introducing them to a car. OK,...

  • RE: Hidden RBAR: Triangular Joins

    I agree, in parts, with everybody here. Yes, I have fixed badly designed code. Some of it was my own. ("What was I thinking when I did...

  • RE: Hidden RBAR: Triangular Joins

    You are welcome. One has to have more tools in the belt in order to avoid "if all you have is a hammer, everything looks like a nail". ...

  • RE: Hidden RBAR: Triangular Joins

    Sorry, Jeff. I was not clear enough. My contention is that a C# CLR proc and a VB CLR proc would run the same as each other.

    You are...

  • RE: Hidden RBAR: Triangular Joins

    I was planning on staying out of this part of the argument, discussion, tirade, whatever, but then you have to remember that it's me.

    I'm a developer. To me SQL...

  • RE: Can I use Calced field in same query?

    If you are on SQL 2005 or later look at putting your calculation into a CTE (Common Table Expression). See books on line or Google for details.

  • RE: The Hassles of Travel

    Carla Wilson (1/15/2009)


    (In fact, I love reading the posts by the UK members, because of the language nuances.)

    For one who grew up listening to "The BBC World Service" and "The...

  • RE: Risky Backups

    Wayne West (1/13/2009)


    ... I don't really see the database size as significant, though. You'd also need to consider how many servers, how many instances (not the same thing),...

  • RE: Risky Backups

    Jason Miller (1/13/2009)


    I prefer the dates YYYYMMDD easier to sort, at least for me.

    I have latched onto ISO-8601 for dates and times. I have long advocated that date/time...

  • RE: Changing Taxonomy

    Ninja's_RGR'us (1/5/2009)


    Steve Jones - Editor (1/5/2009)


    I've logged a note. Personally I think I'd like an hourly email rather than 20-30 a day.

    Doesn't that make 24 e-mails a day anyways? :w00t:

    As...

  • RE: Changing Taxonomy

    GilaMonster (12/29/2008)


    Since nobody uses 2000 any more (right? :hehe: ), nobody will look in SQL2000 to see my post! (unless you're one of those "latest posts"). I...

  • RE: Changing Taxonomy

    Thank good design in that you won't have to change a post URL. Any idea how many external links there are back into here? Whoosh!

Viewing 15 posts - 436 through 450 (of 820 total)