This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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?