Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

EXCEPT 2 Expand / Collapse
Author
Message
Posted Saturday, March 1, 2014 11:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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

Before posting a performance problem please read
Post #1546657
Posted Sunday, March 2, 2014 5:29 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:36 AM
Points: 3,076, Visits: 3,193
Question is identical with that of 2014/02/26.
The answer is also identical.

Am I missing something?




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1546695
Posted Sunday, March 2, 2014 11:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:52 AM
Points: 2,591, Visits: 2,445
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?
Post #1546722
Posted Sunday, March 2, 2014 11:34 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 3,388, Visits: 2,019
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!
Post #1546785
Posted Sunday, March 2, 2014 11:48 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Easy one, thanks.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1546789
Posted Monday, March 3, 2014 1:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:33 AM
Points: 1,030, Visits: 2,338
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.
Post #1546806
Posted Monday, March 3, 2014 1:28 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:11 AM
Points: 1,847, Visits: 508
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...
Post #1546811
Posted Monday, March 3, 2014 3:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:39 AM
Points: 1,379, Visits: 662
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.
Post #1546832
Posted Monday, March 3, 2014 3:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:52 AM
Points: 2,591, Visits: 2,445
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.
Post #1546833
Posted Monday, March 3, 2014 4:15 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 743, Visits: 962
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!
Post #1546842
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse