EXCEPT 2

  • 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]

  • 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

  • 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?

  • 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!

  • Easy one, thanks.

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

  • 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.

  • 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...

  • 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

  • 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.

  • 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!

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

  • 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....

  • 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...

  • 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