In Airline Reservation System, I want to determine the various connectivities between two different cities. There might be N combinations for the above query. i.e A-->B-->C-->D A-->E-->F-->D A-->E->D How will I solve this problem in MS-SQL, do we have the facility for recursion with tables. And one more doubt : What is exactly a leg?
posted 13 years ago
hi!! Actually....it is a very complex problem... and typically i know 2 ppl who can solve it... 1. ME 2. Niranjan
I wont help u coz i got more important work to do... u can ask niranjan... he knows ER diagram very well.... bye!! P.S. plz be polite to niranjan....