5 Replies Latest reply: Nov 7, 2011 3:34 PM by jörnheitmann RSS

    Help wanted!!! I have to import vertical data into horizontal recordset. How can I do this?

      There is the table CustOrdValues in the MSSQL-database:

      Fields: customer, order, kind of value, amount

       

      There are 10 recordsets per customer and order and I need all the amounts in one single recordset like:

      customer, order, amount of kind1, amount of kind2, amount of kind3, amount of kind4, amount of kind5, amount of kind6, ...

       

      I think it should be very easy but I have no idea...

       

      Thank for quick answers..

       

      Jörn