Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Intersecting - 1 Expand / Collapse
Author
Message
Posted Tuesday, February 25, 2014 8:05 PM


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 Intersecting - 1

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 #1545200
Posted Tuesday, February 25, 2014 10:28 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 20, 2016 3:52 PM
Points: 1,818, Visits: 836
Intersecting question thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1545214
Posted Wednesday, February 26, 2014 12:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 19,920, Visits: 18,139
Thanks Ron



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1545230
Posted Wednesday, February 26, 2014 12:47 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:25 AM
Points: 15,251, Visits: 13,059
Easy one, thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1545237
Posted Wednesday, February 26, 2014 1:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:38 AM
Points: 5,170, Visits: 6,887
Easy one, thanks Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1545239
Posted Wednesday, February 26, 2014 1:17 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 @ 1:37 AM
Points: 3,246, Visits: 3,086
First time I see 99% OK.
Post #1545247
Posted Wednesday, February 26, 2014 1:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 2,216, Visits: 7,949
2 points!
Post #1545263
Posted Wednesday, February 26, 2014 3:14 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 22, 2016 3:12 AM
Points: 1,807, Visits: 6,108
I had to go and run this one because I couldn't believe the answer was as simple as it first appeared. Lo and behold, it *was* that simple!
Post #1545290
Posted Wednesday, February 26, 2014 3:17 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 2,216, Visits: 7,949
Of course the correct answer isn't an option. It fails with an error saying that column X does not exist...
Post #1545292
Posted Wednesday, February 26, 2014 3:22 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 22, 2016 3:12 AM
Points: 1,807, Visits: 6,108
Toreador (2/26/2014)
Of course the correct answer isn't an option. It fails with an error saying that column X does not exist...


Depends on the collation setting for the database, doesn't it? I believe the default install option is for a case-insensitive collation, in which case, the script as presented works fine.
Post #1545293
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse