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..