shikhar_0511 (8/25/2012)
Actually the data consist of tonnage from each and every origin to each and every destination .... For the return trip from Texas a tonnage value of 0 will be stored as actually there was no return trip ... In this kind of data I want output like the one I specified before ... Thnx for the help
Please write some insert statements that explain what the data looks like. Don't use real data, but mock up the real data types and structures.
Also, once you have sample data, then explain what it means.