• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Query for Airline Reservation

 
Atul Prabhu
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Sayyed JI
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic