<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by bitbucket
»
INTERSECT 2
30 posts, Page 2 of 3
««
1
2
3
»»
INTERSECT 2
Rate Topic
Display Mode
Topic Options
Author
Message
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, June 19, 2012 5:07 AM
SSCrazy Eights
Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364,
Visits: 6,462
Mighty (6/19/2012)
I might overlook something, but aren't option 2 and 3 the same?
Nope, they are the same. The idea was probably that one of the two didn't have the DISTINCT clause.
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
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1317894
Thomas Abraham
Thomas Abraham
Posted Tuesday, June 19, 2012 5:31 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 1,146,
Visits: 1,448
Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.
A totally unrelated aside: Back from vacation. Missed the QotD. Didn't miss work.
Spent 17 days in Greece. PLEASE consider a vacation there this year. The place is almost devoid of tourists, and for no good reason. In spite of their troubles, the Greeks were as gracious, warm, and hospitable as ever.
End of totally unrelated comment.
Please don't go. The drones need you. They look up to you.
Post #1317907
mbova407
mbova407
Posted Tuesday, June 19, 2012 6:08 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 6:38 AM
Points: 1,326,
Visits: 420
it really helped that #2 and #3 are exactly the same, then i knew about the distinct so by process of elimination.... 1 pt.
Post #1317936
mbova407
mbova407
Posted Tuesday, June 19, 2012 6:09 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 6:38 AM
Points: 1,326,
Visits: 420
no riots?
Post #1317939
mbova407
mbova407
Posted Tuesday, June 19, 2012 6:21 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 6:38 AM
Points: 1,326,
Visits: 420
Thomas Abraham (6/19/2012)
Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.
A totally unrelated aside: Back from vacation. Missed the QotD. Didn't miss work.
Spent 17 days in Greece. PLEASE consider a vacation there this year. The place is almost devoid of tourists, and for no good reason. In spite of their troubles, the Greeks were as gracious, warm, and hospitable as ever.
End of totally unrelated comment.
no riots?
Post #1317946
Thomas Abraham
Thomas Abraham
Posted Tuesday, June 19, 2012 6:25 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 1,146,
Visits: 1,448
mbova407 (6/19/2012)
no riots?
The five days we were in Athens, right up to the 15th, there was nada. We did see a gathering of about 500 people for a speech. The media has sensationalized the situation and given an overdramatic picture of what is going on.
The result: we went to a beach, about 10 km long, on the western coast of the Peloponnese, and there were 6 people on the beach at noon!
Please don't go. The drones need you. They look up to you.
Post #1317950
Ernie Schlangen
Ernie Schlangen
Posted Tuesday, June 19, 2012 6:33 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, April 30, 2013 6:32 AM
Points: 1,592,
Visits: 352
mbova407 (6/19/2012)
it really helped that #2 and #3 are exactly the same, then i knew about the distinct so by process of elimination.... 1 pt.
+1
Post #1317955
Sean Lange
Sean Lange
Posted Tuesday, June 19, 2012 7:37 AM
SSCrazy Eights
Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 8,547,
Visits: 8,204
Thomas Abraham (6/19/2012)
Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.
I suspect you actually use outer joins far more frequently than you think.
A left join is the same thing as a left outer join. The outer keyword is optional.
_______________________________________________________________
Need help? Help us help you.
Read the article at
http://www.sqlservercentral.com/articles/Best+Practices/61537/
for best practices on asking questions.
Need to split a string? Try Jeff Moden's
splitter
.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Post #1318014
Thomas Abraham
Thomas Abraham
Posted Tuesday, June 19, 2012 7:53 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 1,146,
Visits: 1,448
Sean Lange (6/19/2012)
Thomas Abraham (6/19/2012)
Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.
I suspect you actually use outer joins far more frequently than you think.
A left join is the same thing as a left outer join. The outer keyword is optional.
Of course you are correct. My mind must still be on that beach. Thanks for correcting me.
Please don't go. The drones need you. They look up to you.
Post #1318034
Sean Lange
Sean Lange
Posted Tuesday, June 19, 2012 7:55 AM
SSCrazy Eights
Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 8,547,
Visits: 8,204
Thomas Abraham (6/19/2012)
Sean Lange (6/19/2012)
Thomas Abraham (6/19/2012)
Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.
I suspect you actually use outer joins far more frequently than you think.
A left join is the same thing as a left outer join. The outer keyword is optional.
Of course you are correct. My mind must still be on that beach. Thanks for correcting me.
I wish my mind was still on the beach...so jealous. Sounds you had a great time.
_______________________________________________________________
Need help? Help us help you.
Read the article at
http://www.sqlservercentral.com/articles/Best+Practices/61537/
for best practices on asking questions.
Need to split a string? Try Jeff Moden's
splitter
.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Post #1318036
« Prev Topic
|
Next Topic »
30 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
