Home Forums SQL Server 2005 T-SQL (SS2K5) How to Build a single row with groups of fields from several rows per key RE: How to Build a single row with groups of fields from several rows per key

  • It is just an example, my data is more complicated.

    Actually I have from 0 to 15 data/trailer rows (like orders) for each customer.

    Now I need to send the customer data _including_ all it's order/trailers in 1 single (long) row.

    My example imitates these "order" rows which I need to combine into up to 15 "groups" of fields in the output row and glue them to each customer data.

    I hope I clarified myself.

    Thanks