Post reply

EXCEPT 2

  • March 1, 2014 at 11:40 am

    #282963

    Comments posted to this topic are about the item EXCEPT 2

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • March 2, 2014 at 5:29 am

    #1693363

    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    Igor Micev,My blog: www.igormicev.com

  • March 2, 2014 at 11:46 am

    #1693387

    Igor Micev (3/2/2014)

    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

  • March 2, 2014 at 11:34 pm

    #1693434

    Carlo Romagnano (3/2/2014)

    Igor Micev (3/2/2014)

    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

  • March 2, 2014 at 11:48 pm

    #1693438

    Easy one, thanks.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • March 3, 2014 at 1:09 am

    #1693449

    KWymore (3/2/2014)

    Carlo Romagnano (3/2/2014)

    Igor Micev (3/2/2014)

    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

    me : 0; Deja vu: 1

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • March 3, 2014 at 1:28 am

    #1693454

    Raghavendra Mudugal (3/3/2014)

    KWymore (3/2/2014)

    Carlo Romagnano (3/2/2014)

    Igor Micev (3/2/2014)

    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

    me : 0; Deja vu: 1

    At least I am not the only one almost getting confused...

  • March 3, 2014 at 3:13 am

    #1693472

    I guess there is something wrong with this question as it should be like follows:

    SELECT X AS 'Except'

    FROM A

    EXCEPT

    SELECT Y

    FROM B

    but maybe the author took it copy/paste from his 1st question and forgot to change the code.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • March 3, 2014 at 3:22 am

    #1693473

    Hany Helmy (3/3/2014)

    I guess there is something wrong with this question as it should be like follows:

    SELECT X AS 'Except'

    FROM A

    EXCEPT

    SELECT Y

    FROM B

    but maybe the author took it copy/paste from his 1st question and forgot to change the code.

    I don't think so, the answers are incompatibile, too.

  • March 3, 2014 at 4:15 am

    #1693480

    KWymore (3/2/2014)

    Carlo Romagnano (3/2/2014)

    Igor Micev (3/2/2014)

    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

  • March 3, 2014 at 5:04 am

    #1693492

    Same question as 26/02/2014, same answer -> easy one, thanks :hehe:

  • March 3, 2014 at 5:27 am

    #1693502

    It was a nice, easy one to start the week, so thanks.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • March 3, 2014 at 8:45 am

    #1693579

    I keep waiting for the SQL Server database engine to add the ability to use "CORRESPONDING BY" with set difference queries such as these. Good thing I haven't held my breath....

  • March 3, 2014 at 9:35 am

    #1693613

    sneumersky (3/3/2014)

    I keep waiting for the SQL Server database engine to add the ability to use "CORRESPONDING BY" with set difference queries such as these. Good thing I haven't held my breath....

    Yeah, I wish the SQL language standard incorporated

    INSERT CORRESPONDING INTO a

    SELECT * FROM b

    Well, there is a way around it...

  • March 3, 2014 at 9:36 am

    #1693614

    Ron, I always enjoy your QotDs - thanks!

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy