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?
http://msdn.microsoft.com/en-us/library/ms177410(SQL.90).aspx http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/
