2 Replies Latest reply: Jun 29, 2012 7:34 AM by Philippe Motillon RSS

    Concatenate same fields from different rows

      Hello,

      I have a table containing these information

       

      Num , Value

      1 , A

      1, B

      2 , V

      3, A

      3 , D

      4 , E

       

      I would like to create a table with the following fields

       

      Num Value

      1 , A|B

      2 , V

      3 , A|D

      4 , E

       

       

      any idea ?

       

      The data source is an SQL server 2008 Database.

       

      Thanks for your help

       

      Philippe