Friday, February 17, 2012

db hierarchy

HI!
I am new in DB so I need some advices for finding the right solution.
I need to be able to make automatically any join between tables which the user choose and deliver the result.
is like making an hierarchy between all tables in DB (parent-child) and then making the select statement for the right join.

if u have any idea about how can I manage this, pls help me.

thanks a lot!I would start by getting a beginner sql server programming book.|||Automatically? You will need to define all your table relationships, and then write code that will will dive into the system tables to find these relationships.

Not an easy coding challenge.

I suggest you look for third party software that will do this, as I suspect that you are reinventing the wheel.

No comments:

Post a Comment