How to make dynamic joins of a table with itself?

[Former Member]

I would like to get some help about this: I'm trying to make a stored procedure that takes an integer N, and then performs N inner joins between the table T and itself.

It is like if I could add dynamically some columns of the table in function of a parameter.

Any tips?

[former_member182302 · Accepted solution]

Hi Jose,

Answered to a similar question in this thread

Regards,

Krishna Tangudu