SQL Server Performance

Pivot

Discussion in 'Getting Started' started by lcerni, Aug 20, 2009.

  1. lcerni New Member

    If I have this in a temp table
    product_id manuf_id client_id contract_cd qty_gr bin
    a 5 44 x 18 A1A
    a 5 44 x 18 C2C

    how do I use pivot to make it look like this
    product_id manuf_id client_id contract_cd qty_gr bin
    a 5 44 x 18 A1A, C2C
    I have been looking for examples but they all seem to sum a value. Should I not be using pivot? Should I be using something else?
  2. Madhivanan Moderator

  3. MohammedU New Member

  4. lcerni New Member

    Yes, this is exactly what I was looking for. Also, thank you for teaching me something new.

Share This Page