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

Complex joins Expand / Collapse
Author
Message
Posted Wednesday, December 7, 2011 1:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:57 AM
Points: 13,292, Visits: 11,079
Wow, another excellent question Hugo. 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 #1217634
Posted Wednesday, December 7, 2011 3:30 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:14 PM
Points: 5,364, Visits: 8,952
L' Eomot Inversé (12/6/2011)
It's another one where I'm surprised by the failure rate - 78% wrong answers is amazing. Does that mean that 78% of people here never write or read complex queries?


I don't find it all that surprising, Tom. It seems like most of the stuff I'm fixing every day is because once it gets beyond a simple query, a c.u.r.s.o.r is used. Personally, I'm pleased that it's this high.

Hugo - excellent question. I'm thoroughly enjoying these questions you've been posting.


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1218268
Posted Wednesday, December 7, 2011 10:38 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 AM
Points: 1,939, Visits: 1,162
I got it wrong.till now id id not worked on nested joins.thanks i leanred one new point today

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1218365
Posted Wednesday, February 8, 2012 10:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 13, 2013 1:13 PM
Points: 134, Visits: 101
It took around 2 hours for me to solve it and finally got it right

Ofcourse, learnt something new
Post #1249172
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse