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

Incrementing code to add code Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 12:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, September 7, 2013 5:18 AM
Points: 25, Visits: 61
Hi,

I am trying to join the table to itself many times on a condition. Is there a way to automate number of joins based on count of something from another table?

Any help appreciable!

Thanks,
Akber.
Post #1433014
Posted Wednesday, March 20, 2013 3:37 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 3:41 AM
Points: 792, Visits: 4,415
are you doing something that a Recursive CTE could resolve?

http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/
Post #1433088
Posted Wednesday, March 20, 2013 3:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 29, 2016 8:08 AM
Points: 2,934, Visits: 5,473
akberali67 (3/20/2013)
Hi,

I am trying to join the table to itself many times on a condition. Is there a way to automate number of joins based on count of something from another table?

Any help appreciable!

Thanks,
Akber.


Could you please post a bit more details and code you have so far.


_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1433103
Posted Wednesday, March 20, 2013 4:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, September 7, 2013 5:18 AM
Points: 25, Visits: 61
CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.

davidandrews13 (3/20/2013)
are you doing something that a Recursive CTE could resolve?

http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/
Post #1433120
Posted Wednesday, March 20, 2013 5:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:42 AM
Points: 14,469, Visits: 38,080
akberali67 (3/20/2013)
CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.

davidandrews13 (3/20/2013)
are you doing something that a Recursive CTE could resolve?

http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/


sql handles that just fine as long as you rememeber to preface every field with it's table name.
SELECT 
T1.*
T2.*
FROM MyTable T1
LEFT OUTER JOIN MyTable T2 On T1.ID = T2.ID +1




Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1433147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse