Create List of Order Numbers

system · September 16, 2013, 1:26pm

Hi all,
SQL Server 2005 database.
How would i create a list of order no’s for each customer like this, so i can return 1 row per customer. I could get the max and the min but thats about it.

Customer… Order No’s
Cust001… 2101, 2102, 2103, 2104

Table fields below:
-Customer
-Date
-Order No
-Value

Currently i will get 4 rows:
Cust001 2101
Cust001 2102
Cust001 2103
Cust001 2104

Thanks for any help
Goodwin

goodwin (BOB member since 2006-03-06)

system · September 17, 2013, 9:07am

take a look at these posts:

http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html

https://bobj-board.org/t/156849

Thanks,
Raghvendra Deshpande

Raghvendra Deshpande (BOB member since 2008-05-26)

system · September 17, 2013, 10:18am

thanks very much, very helpful

regards
Goodwin

goodwin (BOB member since 2006-03-06)