id        sales_order  tracking_number
  10059     58322        z003001
  10060     58323        z003002
  10061     58323        z003003
  10062     58324        z003004
  10063     58324        z003005

  id        sales_order  tracking_number
  10059     58322        z003001
  10060     58323        z003002, z003003
  10062     58324        z003004, z003005

Declare @T table
(id int,sales_order int,tracking_number varchar(20))

Insert @T

 Select 1, 58322 ,       'z003001' union all
 Select  2,58323 ,       'z003002' union all
 Select  3,  58323 ,       'z003003' union all
 Select  4,58324   ,     'z003004' union all
 Select   5,58324  ,      'z003005'

Select Min(id)as id,sales_order,
Max(Case When seq =1 then tracking_number Else '' End) + ',' +
Max(Case When seq =2 then tracking_number Else '' End) + ',' +
Max(Case When seq =3 then tracking_number Else '' End) + ',' +
Max(Case When seq =4 then tracking_number Else '' End)as tracking_number
from
(Select s.id,s.sales_order,tracking_number,
(Select Count(*) from @T Where sales_order =s.sales_order
and tracking_number <=s.tracking_number)as seq
from @T s)M
Group by sales_order

quote:

---

Originally posted by nstrong

It's a MySQL server.

Wait, is this a Microsoft-only forum??? :-o

Well, if the MS solution doesn't use any crazy coding, I think I could get it to work in MySQL. :-s

~ Nick

---