November 20, 2013 at 8:54 am
waxb18 (11/20/2013)
Im ever so sorry guys, i didnt see the 2nd pageThe best way to show the result would be to see the spreadsheet attached
OK this is my last attempt here. I am honestly trying to help but you won't give me the information required to help.
Let's take just the first row in your output.
TypeDeparture DateTimeInbound/OutboundDepart FromAirport TerminalArrival DateTimeDestinationBooking RefernceAirlineFlight No.Cost
Flight11/19/2013 0:00OutboundLondonHeathrow Terminal 511/19/2013 0:00Frankfurt123-456-789BABA-123300
Your sample data is missing a lot of this information and the stuff that is there does not match up with your desired output. The dates don't match, the names don't match. There is not destination the flight table and nowhere in any of your tables do we find Frankfurt.
I can imagine you are frustrated but without example output that actually matches the data we can't do anything.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply