nEED HELP IN DISPLAYING COLUMN VALUES IN TOWS

• rajkiran-331110

  SSC Enthusiast

  Points: 194

  More actions

  September 11, 2008 at 4:40 am

  #192738

  tradenumber Memotype memovalue

  t1 mt1 mv1

  t1 mt2 mv2

  t1 mt3 mv3

  I wanted to display the columns like this

  tradenumber mt1 mv1 mt2 mv2 mt3 mv3

  Any idea is highly appreciated.

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  September 30, 2008 at 3:04 am

  #878720

  Why? Can't you do that in the client application?

  Have you tried googling "cross-tab query"?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com