Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 7,484 total)

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    david.holley (4/5/2013)


    I don't know if you can do that with a TallyTable or if a TT is neccessary. This is a function that should accomplish it. It simply adds the...

  • RE: Are the posted questions getting worse?

    GilaMonster (4/5/2013)


    Am I the only person who gets 'I don't think that's true' replies to their posts from a certain person and am I the only one annoyed by it?

    I...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/5/2013)


    Here is what I really want to say in response to the OPs last post in another thread:

    sql-lover (4/5/2013)


    GilaMonster (4/5/2013)


    sql-lover (4/5/2013)


    So I wanted to open a case and...

  • RE: LEFT JOIN

    Hugo Kornelis (4/4/2013)


    bev.kaufman (4/4/2013)


    Okay, then how would you have written a left outer join if you wanted to fetch only the records where the left side had flag = 1?

    SELECT...

  • RE: LEFT JOIN

    kapil_kk (4/4/2013)


    Thanks for the explanation TOM..

    What about AND if we used in place of WHERE?

    You can't use AND in place of WHERE. In a select statement, any AND is...

  • RE: LEFT JOIN

    bev.kaufman (4/4/2013)


    I too had trouble with the wording of the options, and ended up picking the first (and wrong) option because the other three looked like they couldn't be true....

  • RE: Assigning values to Variables with CASE

    Since I mistakely thought (until I looked a bit harder) that the correct answer wasn't an option, I assumed the missing batch separator was a mistake and picked the 5...

  • RE: TRY...CATCH

    I had forgotten were not there that the ";" is not alowed in there.

    And didn't even notice that THROW would cause an error on three of the...

  • RE: LEFT JOIN

    I like the question. Not of course the form and wording of the answers (|I won't say more than that as Hugo has covered it fullyHugo) but the...

  • RE: SQL Server Error Handling

    KWymore (4/1/2013)


    I knew this had to be a trick question because I couldn't see why MS would add that command. As Tom said, rolling back a rollback is nonsense. Being...

  • RE: Today's Random Word!

    Daniel Bowlin (4/1/2013)


    Rob Schripsema (3/29/2013)


    SQLRNNR (3/29/2013)


    JAZZ Master (3/29/2013)


    SQLRNNR (3/28/2013)


    Cliff Jones (3/28/2013)


    bcsims 90437 (3/28/2013)


    Terry300577 (3/28/2013)


    Cadence

    Chirunning

    (Just did 4 days of chirunning/chiwalking instructor training, and got the topic of 'cadence' for my practical...

  • RE: SQL Server Error Handling

    Amusing question :-P.

    Timeouts can cause rollback, but rollback pays no attention to them if they happen while it is executing - it just ignores it - because...

  • RE: LEN()

    Primo Dang (3/29/2013)


    L' Eomot Inversé (3/29/2013)


    Primo Dang (3/29/2013)


    I'm glad so many people enjoyed it, thank you! =]

    I decided to submit this question when I saw this question from 2010[/url], because...

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/29/2013)


    WayneS (3/29/2013)


    Koen Verbeeck (3/28/2013)


    Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.

    Because someone has to answer all those BI questions...

  • RE: LEN()

    Primo Dang (3/29/2013)


    I'm glad so many people enjoyed it, thank you! =]

    I decided to submit this question when I saw this question from 2010[/url], because some people mentioned there should...

Viewing 15 posts - 3,601 through 3,615 (of 7,484 total)