Oh! Now I understand what You’re asking. In the future, only post a question once, then carry on in the discussion thread. It keeps the forums a lot cleaner.
Unfortunately I’m pretty sure you can’t do what you’re suggesting in SQL Server, because that would require each Customer to have a dynamic amount of fields, and combine entries from the same table to get those fields. I would suggest just Ordering or Grouping by the Customer ID, and using the results that way. Do you just want to create these entries to print, or are you using this data within another program? Within that program you might be able to manipulate this output to your desired format.
<pre>select customer invoice_no invoice_amount due_date from Table ORDER BY Customer DESC</pre>
Take a look at this link, it should help with you with your issue. What you are trying to do is a dynamic pivot.
The best way to handle this is in the client side code. Have the client code loop through the recordset stringing the data into a string until you get to the next customer record.