Forum Replies Created

Viewing 15 posts - 1,771 through 1,785 (of 7,484 total)

  • RE: CHECK Constraints vs NULL values

    Nice question illustrating the effect of NULLs on CHECK constraints, which I suspect confuses many people. Not surprising that 60% of answers so far have it wrong.

    Looking for FALSE...

  • RE: CDC Administration

    Hugo Kornelis (4/30/2015)


    Stewart "Arturius" Campbell (4/30/2015)


    Interesting question, thanks...

    Now i'm wondering why this might be required, given the temporary nature of objects in tempdb...:-P

    I am convinced that it will never be...

  • RE: COALESCE in Left Join

    I think I must be getting old and decrepit. Got it right, but it strained my brain 🙁

  • RE: CTE Problem Redux

    SQLRNNR (4/28/2015)


    Hey, so far it is improved in % correct. Only 53% got it correct when I asked a very similar question a few years back.

    http://www.sqlservercentral.com/questions/Subquery/75557/

    I wonder how many people...

  • RE: SQL query help

    Sergiy (4/27/2015)


    CELKO (4/22/2015)


    An identifier (<something>_id) is measured on a nominal scale. Math makes no sense on such scales -- what is your credit card number divided by the UPC code...

  • RE: Today's Random Word!

    crookj (4/28/2015)


    Ed Wagner (4/28/2015)


    Revenant (4/28/2015)


    SQLRNNR (4/28/2015)


    TomThomson (4/27/2015)


    SQLRNNR (4/27/2015)


    marlin

    spike

    hall

    fame

    Fortune

    Teller

    Automatic

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/27/2015)


    Ed Wagner (4/27/2015)


    Grant Fritchey (4/27/2015)


    Hey Steve! Where did you get pictures of my cousin?

    I never thought of you as having a strong feline side. 😀

    How many people does...

  • RE: This is a Test post

    Grant Fritchey (4/27/2015)


    I reject your test as completely invalid and a waste of my time and superior intellect along with my ability to craft nonsensical run-on sentences for no purpose...

  • RE: Today's Random Word!

    SQLRNNR (4/27/2015)


    marlin

    spike

  • RE: SQL query help

    CELKO (4/27/2015)


    Calling either a scalar is outrageous: neither is "a quantity having magnitude but no direction, and representable by a single real number" since neither is a quantity...

  • RE: Today's Random Word!

    Eirikur Eiriksson (4/27/2015)


    Ed Wagner (4/27/2015)


    djj (4/27/2015)


    Copper

    Canyon

    Crossing

    Out

  • RE: Using a Window Aggregate in an Aggregate Query

    Very nice question.

    It's interestng that 12% or answers to date appear to come from people who beleive that allorders in any given year must occur on teh same date. ...

  • RE: Drop Databases

    Thanks for thh nice simple question.

    It's quite amusing that 10% of responses so far indicate that people believe tempdb can be dropped. :w00t:

  • RE: SQL query help

    CELKO (4/23/2015)


    ISBN is displayed with dashes for human convenience, but it's actually composed of elements .. again, under the rules for 1NF, each of those should be stored...

  • RE: SQL query help

    Lynn Pettis (4/23/2015)


    CELKO (4/22/2015)


    you really can divide miles by hours and get speed! 🙂

    Also, since you are so picky about using the correct terms, distance divided by time equals velocity!

    Maybe...

Viewing 15 posts - 1,771 through 1,785 (of 7,484 total)