select master/detail data in a single row

• tirthadip

  SSC Rookie

  Points: 34

  More actions

  May 24, 2010 at 4:46 am

  #235389

  I have two tables.

  1st table has the following format:

  table name:student

  structure:

  student_id student_name

  1 John

  2 Marsh

  3 Samuel

  2nd table has the following format:

  table name:paymentDetails

  structure:

  student_id payment month

  1 1000 jan

  1 2000 feb

  1 3000 mar

  2 1000 jan

  i want an output table like following

  studentname payment month payment month payment month

  john 1000 jan 2000 feb 3000 mar

  please keep in mind that my details table(paymentDetails) can have any number of rows for a particular student_id

  I have read a lot of articles about cross apply/cross join/cross tabs/pivots ....but cant resolve my problem

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  May 24, 2010 at 5:05 am

  #1171464

  Probably, you wil lhave to take a look at the following article on Dynamic Cross Tabs , written very well one of the SQL gurus , Jeff Moden;

  Click this to go through: Dynamic Cross Tabs

  [/url]