Table Report related Query

• vasanti mestri

  Right there with Babe

  Points: 786

  More actions

  March 5, 2010 at 5:36 am

  #386447

  Hi,

  i have table in database like this

  property grade1 grade2 comments

  test1 4 4 aaaaa

  test2 3 4 vvvvv

  i want to show it in report like this

  test1 grade1 4

  test2 grade1 3

  test1 grade2 4

  test2 grade2 4

  anyone having idea?.....pls help me.....

• veeren4urs

  SSCrazy

  Points: 2763

  More actions

  March 5, 2010 at 10:47 am

  #1129314

  Hi,

  Before that genrate query result like that in Sql then u can do this by using table...

  Thanks

  Veeren

  Thanks & Regards,
  Veeren.
  Ignore this if you feel i am Wrong. 😉

• Jeff Moden

  SSC Guru

  Points: 1004405

  More actions

  March 5, 2010 at 8:33 pm

  #1129548

  vasanti mestri (3/5/2010)

  ---

  Hi,

  i have table in database like this

  property grade1 grade2 comments

  test1 4 4 aaaaa

  test2 3 4 vvvvv

  i want to show it in report like this

  test1 grade1 4

  test2 grade1 3

  test1 grade2 4

  test2 grade2 4

  anyone having idea?.....pls help me.....

  Take a look at UNPIVOT on the T-SQL side of the house.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)