Incrementing code to add code

Question

Post reply

Incrementing code to add code

akberali67

SSC Eights!

Points: 995
More actions
March 20, 2013 at 12:25 am

#291254

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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

davidandrews13 SSCertifiable Points: 6792 More actions · Answer 1

are you doing something that a Recursive CTE could resolve?

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

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

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!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

akberali67 SSC Eights! Points: 995 More actions · Answer 3

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/%5B/quote%5D

Lowell SSC Guru Points: 323504 More actions · Answer 4

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/%5B/quote%5D%5B/quote%5D

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!