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: Today @ 3:05 PM
Points: 3,261, Visits: 3,456
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: 2 days ago @ 1:49 AM
Points: 2,748, Visits: 2,605
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: 2 days ago @ 8:00 AM
Points: 3,520, Visits: 2,069
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: Friday, March 20, 2015 5:52 AM
Points: 2,643, Visits: 2,070
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 @ 12:18 PM
Points: 1,200, Visits: 2,637
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: Friday, March 6, 2015 5:15 AM
Points: 1,977, Visits: 537
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: Yesterday @ 11:25 PM
Points: 1,879, Visits: 795
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: 2 days ago @ 1:49 AM
Points: 2,748, Visits: 2,605
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: Thursday, March 26, 2015 6:12 AM
Points: 776, Visits: 992
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