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 Monday, March 3, 2014 5:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 8, 2015 2:11 AM
Points: 1,018, Visits: 396
Same question as 26/02/2014, same answer -> easy one, thanks
Post #1546855
Posted Monday, March 3, 2014 5:27 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 2, 2015 9:10 PM
Points: 5,976, Visits: 5,404
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
Post #1546866
Posted Monday, March 3, 2014 8:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
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....
Post #1546954
Posted Monday, March 3, 2014 9:35 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:18 PM
Points: 4,581, Visits: 3,801
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...
Post #1546992
Posted Monday, March 3, 2014 9:36 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:18 PM
Points: 4,581, Visits: 3,801
Ron, I always enjoy your QotDs - thanks!
Post #1546993
Posted Monday, March 3, 2014 9:41 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:06 AM
Points: 8,587, Visits: 10,354
Looks as if a duplicate got published instead of today's intended question.

Tom
Post #1546997
Posted Monday, March 3, 2014 9:48 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:18 PM
Points: 4,581, Visits: 3,801
TomThomson (3/3/2014)
Looks as if a duplicate got published instead of today's intended question.

It's a good one, why not to rub it in?
Post #1547008
Posted Monday, March 3, 2014 10:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, June 24, 2015 5:03 PM
Points: 2,106, Visits: 2,251
Between the rerun on the question and the constant snow, it's beginning to feel like "Groundhog Day".

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1547025
Posted Monday, March 3, 2014 4:33 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 3:39 PM
Points: 630, Visits: 1,502
I do appreciate the easy point, even though I don't think I earned it.
Post #1547122
Posted Monday, March 3, 2014 5:01 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, June 26, 2015 12:58 AM
Points: 1,814, Visits: 806
Groundhog day ?

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1547131
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse