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