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: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
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: Yesterday @ 7:01 AM
Points: 3,014, Visits: 3,101
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: Yesterday @ 1:00 AM
Points: 2,563, Visits: 2,420
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: Monday, October 20, 2014 11:29 AM
Points: 3,354, Visits: 2,001
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 @ 3:04 AM
Points: 1,008, Visits: 2,298
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 @ 1:26 AM
Points: 1,812, Visits: 498
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:27 AM
Points: 1,321, Visits: 632
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: Yesterday @ 1:00 AM
Points: 2,563, Visits: 2,420
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: Sunday, October 12, 2014 11:25 PM
Points: 717, Visits: 938
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