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
Posted Wednesday, December 7, 2011 1:50 AM



Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 14,849, Visits: 12,895
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1217634
Posted Wednesday, December 7, 2011 3:30 PM



Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 5,736, Visits: 9,836
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.

Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
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



Group: General Forum Members
Last Login: Wednesday, July 29, 2015 11:50 PM
Points: 1,967, Visits: 1,189
I got it wrong.till now id id not worked on nested joins.thanks i leanred one new point today

Post #1218365
Posted Wednesday, February 8, 2012 10:04 AM


Group: General Forum Members
Last Login: Tuesday, September 15, 2015 5:21 AM
Points: 136, Visits: 111
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