Reg:Select Statement with row as Column

• ms.shanthi

  Newbie

  Points: 8

  More actions

  May 26, 2008 at 5:54 am

  #186994

  Hi,

  I Have two tables.

  Table1 has the following columns:

  TableID

  FieldID

  FieldName

  FieldValue

  DateAdded

  and Table2 has athe following Columns

  FieldID

  TableID

  Dataadded

  And I want to display Each FieldName as a Column name for Dridview control.How can i form SELECT Statement To Achieve this ?

  Thanks in advance

  sri

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  May 27, 2008 at 10:19 am

  #820664

  [font="Verdana"]Search for PIVOT in BOL.

  Mahesh[/font]

  MH-09-AM-8694