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: Sunday, January 4, 2015 7:55 AM
Points: 5,333, Visits: 25,280
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: 2 days ago @ 2:26 AM
Points: 3,287, Visits: 3,487
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 @ 7:04 AM
Points: 2,772, Visits: 2,633
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: Yesterday @ 9:35 AM
Points: 3,543, Visits: 2,081
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: Wednesday, April 15, 2015 6:43 AM
Points: 2,706, Visits: 2,117
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: Yesterday @ 8:24 AM
Points: 1,233, Visits: 2,687
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 15, 2015 1:49 AM
Points: 2,011, Visits: 540
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:39 AM
Points: 1,919, Visits: 823
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 @ 7:04 AM
Points: 2,772, Visits: 2,633
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: Yesterday @ 6:35 AM
Points: 797, Visits: 1,003
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