Forum Replies Created

Viewing 15 posts - 7,996 through 8,010 (of 10,143 total)

  • RE: Today's Random Word!

    Lynn Pettis (4/12/2010)


    Chris Morris-439714 (4/12/2010)


    RBarryYoung (4/11/2010)


    Tom.Thomson (4/11/2010)


    mbricker-600840 (4/11/2010)


    Tom.Thomson (4/11/2010)


    hippopotomonstrosesquipedalian

    Is that a hippo that uses long words?

    No, it's a sesquipedalian autological autonym. :hehe:

    ??? Really? I thought that it was...

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • RE: Today's Random Word!

    mbricker-600840 (4/13/2010)


    Chris Morris-439714 (4/13/2010)


    mbricker-600840 (4/13/2010)


    Mugwump

    How do you know this word, Mike? AFAIK it's the obscure Cornish word for a large slug!

    The word actually derived from and American Indian work meaning...

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • RE: Today's Random Word!

    mbricker-600840 (4/13/2010)


    Mugwump

    How do you know this word, Mike? AFAIK it's the obscure Cornish word for a large slug!

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • RE: Left Join, Count, WHERE clause, Headache

    cawleymj (4/13/2010)


    Hi I am just trying to do a relatively simple Count that includes a Left Join and a WHERE clause.

    I'm trying to break what I'm actually doing down into...

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • RE: Are the posted questions getting worse?

    Roy Ernest (4/12/2010)


    I am back from my vacation... And I am not even going to bother trying to catch up with thread... It will take the next two weeks to...

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • RE: Today's Random Word!

    CirquedeSQLeil (4/12/2010)


    paresseux

    Oh no not another foreign word. Well I can't be bothered to look it up.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • RE: Help with REPLACE please!!!!

    skeeter042 (4/12/2010)


    Sorry, I'm not following you. :unsure: Can you give me another example after looking at all of my original code?

    select rowid, accountnumber, tenantnumber, accountname, serviceaddress, billtoaddress1,

    case

    when...

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • Viewing 15 posts - 7,996 through 8,010 (of 10,143 total)