getting data from single column and inserting into multiple columns

• jyothirmayi.cr

  Grasshopper

  Points: 17

  More actions

  June 27, 2008 at 4:43 am

  #381427

  example

  col1 col2 sno

  firmno 1 1

  firmtype ABS 2

  name XYZ 3

  type XXX 4

  desc AAA 5

  output table should be

  firmno firmtype name type desc

  1 ABS XYZ XXX AAA

• Lowfar

  Ten Centuries

  Points: 1005

  More actions

  June 27, 2008 at 4:55 am

  #835249

  Hi

  If you are using SQL2005, have a look at the PIVOT function in Books on-line.