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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, November 8, 2014 1:44 AM
Points: 934, Visits: 378
Same question as 26/02/2014, same answer -> easy one, thanks
Post #1546855
Posted Monday, March 3, 2014 5:27 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:35 AM
Points: 4,482, Visits: 3,938
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: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
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: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Ron, I always enjoy your QotDs - thanks!
Post #1546993
Posted Monday, March 3, 2014 9:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 7,874, Visits: 9,613
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: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, November 24, 2014 10:03 AM
Points: 1,895, Visits: 2,194
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 9:07 AM
Points: 421, Visits: 1,193
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: Yesterday @ 7:47 PM
Points: 1,804, Visits: 780
Groundhog day ?

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1547131
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse