twindaddy

I am looking for a solution for the following : I am working with MS SQL Server management Studio. I have a table with customer number, and each customer can have 10 segmentations. Now i need to have the segmentation on 1 row to display. But i get 10 times the customer which the segmentation. Now it is : Customer 1 Segmentation 1 Customer 1 Segmentation 2 ...... How can I have : Customer 1 Segmentation 1 Segmentation 2 ..... Customer 2 Segmentation 1 Segmentation 2 ..... Thx