Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Question Unanswered: converting column feild values in a table to column names in other table

    Table-A is having 4 columns. I want to select values from Table-A with values from Event columns in table-A as column names in table-B as shown in Table-B. I need a stored procedure for the same, if its possible.
    TABLE-A
    ID.No Name Event AmountPaid
    1 Terry ReliefFund 100
    1 Terry Donation 200
    2 John Festival 100
    2 John Donation 300


    TABLE-B
    ID.No Name ReliefFund Donation Festival
    1 Terry 100 200 0
    2 John 0 300 100


    plz help.... thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check your client software for it's PivotTable or Cross Tabulation support. This functionality is really best handled on the client side, not the server side.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •