I have a travel related application.and tables Busmaster and Busdetails.
Busmaster contains busid,model,busname
Busdetails contains busid,tourdate,bookdate,fare,status. and there are 4 buses.
in every month 4 buses will be booked for some days.
my requirement is if i select a month and year from dropdown boxes i want to display details of the month
following is sample output like this
date 100 101 102 103
2013-08-01 booked available booked booked
2013-08-02 available booked available available
2013-08-31 availabble booked available available
here 100,101,102,103 are busid's how it is possible i trid this using pivot but not working
idea is if tourdate in busdetails matches with particular date the display booked otherwise available.
above data is sample of 2013 august.
any body know help me