Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 3,348 total)

  • RE: Update table

    codebyo (10/24/2011)


    wware (10/24/2011)


    OK, I just got it, thanks to mtassin's explanation and my reread of Hugo's original explanation ("there are no other columns in the table.") In this scenario,...

  • RE: Update table

    wware (10/24/2011)


    I'm impressed with all the contributions on how to skin this cat but if we were to vote for our favorite based on readability, I choose this one:

    UPDATE table1...

  • RE: Update table

    Kenneth J. Moore (10/24/2011)


    syntax is certainly wrong unless it is a char type in the answers.

    Even if the column is of a numeric type, the syntax of the correct answer...

  • RE: Update table

    lrosini (10/24/2011)


    I got the answer correct but the question is very misleading. The name of the column is Column1 not col1 as it's referred to in the answers. So really...

  • RE: Update table

    Captain Miserable (10/24/2011)


    I agree - a simple case statement seems much more straight forward. Is there a reason why the subquery would be more effective?

    No.

    Either the question's author...

  • RE: Update table

    I agree with several others that there are much easier and much more elegant ways to achieve this. The code in the correct answer would not get past me if...

  • RE: Resource Pools

    What, only three so far? I had expected at least 30 "I want my point back" posts by now! 😉

  • RE: Use of BETWEEN and DATETIME

    theandrweryder (9/28/2011)


    I too thought the question was fine - its the answer I have a problem with.

    Hands up all those who think this is a bug

    *keeps hands demonstratively down*

    The meaning...

  • RE: Use of BETWEEN and DATETIME

    OCTom (9/27/2011)


    I see this as no trick. Why would anyone make the assumption that date1 is the from date and date2 was the to date?

    I did not make that assumption....

  • RE: Use of BETWEEN and DATETIME

    I missed it. My bad for not reading the code accurately enough.

    Though, with the reversed order of the assignments, one might ownder if the author was trying to educate us...

  • RE: Know Your SQL Objects

    cfradenburg (5/13/2011)


    Hugo Kornelis (5/13/2011)


    Again: WHAAT???

    I don't have the time right now to read the entire discussion....

    If you don't have time to read the entire discussion please don't go on a...

  • RE: Know Your SQL Objects

    WHAAT???

    In the daily newsletter, the question specifies to "select 4". Which is what I did. And then I find that the site thinks I am wrong, because both "Extents may...

  • RE: Consistent Data Presentation

    When I saw the newsletter, which presents only the question but not the answer options, I was afraid that this would be a debatable question, since many design best practices...

  • RE: Foreign Keys

    Tom.Thomson (4/12/2011)


    I think you've misunderstood horribly what I said.

    Maybe. Or maybe I just did not express myself clear enough.

    I'm not suggesting squeezing anything into a column: what I am saying...

  • RE: Foreign Keys

    UMG Developer (4/12/2011)


    Hugo Kornelis (4/12/2011)


    What I think David means with his replies is that the data model should not have combined these atrtbiutes into a single table. You'd either have...

Viewing 15 posts - 2,371 through 2,385 (of 3,348 total)