I was planning to format it like that with ASP.

All i want SQL to give me is the line detail for each destination for each day (already got) and the...

i meant columns honest

the output I am looking for is this..

DATE

DESTINATION

DESTINATION DETAIL 1 FOR EACH DESTINATION...