General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Conept to create relation between contacts
It is about managing your contact (like openbc, orkut etc?). Where I am having some contact and my contacts are having their contact, with this philosophy it is said that on sixth degree you are connected with other person.
Scenario is like this suppose I am logged in and searching for contact, I make some query and based on it I find some contacts, so we have show a path ohw I m connected with this searched contact.
Typical data may look like below
contact contact`s contact
milan vihar
milan sandip
milan manish
vihar bhavya
vihar milan
vihar jaimin
sandip vihar
sandip milan
sadnip jaimin
manish bhavya
manish sandip
so when i search for bhavya then path to bhavya are
Milan->Vihar->bhavya
Milan->manish->bhavya
path to jaimin
milan->vihar->jaimin
milan->sandip->jaimin
I hope my above example have clear subject.
What I need is if you know some way to do this job using MS SQL server like how to design table to store contact information so it make easy to query such info. Or special MS SQL services to dig such data in high performance environment. bla bla.
If you know somebody down here who can help then let me know
Thanks & Regards
Milan Saraiya