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 ««12

The Right Kind Of Join II Expand / Collapse
Author
Message
Posted Thursday, September 1, 2011 5:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:14 AM
Points: 1,258, Visits: 13,554
thanks Paul!!!

Really, this question is very interesting!!

today , I learned anything!!!!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1168585
Posted Thursday, September 1, 2011 5:48 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Good question, I learned something new today.

http://brittcluff.blogspot.com/
Post #1168601
Posted Thursday, September 1, 2011 7:37 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: 2 days ago @ 8:18 AM
Points: 3,909, Visits: 3,636
Very interesting question, thanks Paul.
Post #1168657
Posted Thursday, September 1, 2011 7:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:18 PM
Points: 2,818, Visits: 2,561
paul.knibbs (9/1/2011)
This is one of those questions where the common sense answer (e.g. both tables have no data in, so of course the answer will be zero rows!) is actually right...I knew nothing about the stuff explained in the answer, so I learned something today.


Me too. Good question and answer, thanks.
Post #1168677
Posted Thursday, September 1, 2011 8:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
Thanks Kiwi! Look forward to the next installment.
Post #1168713
Posted Thursday, September 1, 2011 11:15 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 11, 2011 1:51 PM
Points: 341, Visits: 311
Got it wrong. That's what I get for not really reading it. I just thought it was a duplicate question. Whoops.
Post #1168810
Posted Thursday, September 1, 2011 11:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:25 PM
Points: 1,117, Visits: 1,233
Good question, great explanation.
Thanks!



Post #1168823
Posted Thursday, September 1, 2011 11:52 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: 2 days ago @ 10:23 AM
Points: 3,299, Visits: 1,978
Nice question. Very interesting explanation. Looking forward to question 3!
Post #1168833
Posted Thursday, September 1, 2011 1:52 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:32 PM
Points: 8,738, Visits: 9,284
SQLkiwi (9/1/2011)
Hi Tom,

The third question in this series will be published next week (8 September).
I promise your question will be answered then.

Paul

I'll look forward to it.
As someone with a bit of experience of language design (including functional and relational DMLs) I'm intrigued by what appears to have happened here.


Tom
Post #1168902
Posted Sunday, September 4, 2011 11:43 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:26 AM
Points: 13,622, Visits: 10,514
Interesting question, 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 LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1169838
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse