how to display row value instead of column values

Posted by Klbaiju under Sql Server on 7/4/2013 | Points: 10 | Views : 1373 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

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

Regards

Baiju

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Ssj_Kumar on: 7/10/2013 [Member] Starter | Points: 25

0	This can be done with SQL Pivot, using pivot you can display row value as column value. Go for a dynamic pivot, and your input should be month and year Regards, Jayakumar Selvakani Klbaiju, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts