sorry, if i've confused you.

customers can and do have multiple items in an order. but customers won't have more than one order in a day.

the data reduction has been...

i have got the table i want by running something like

SELECT billdate,custcode,custname,

MAX(CASE WHEN Seq=1 THEN brand ELSE NULL END) AS brand,

MAX(CASE WHEN Seq=1 THEN item ELSE NULL END)...

Hi Jeff, below are the codes. I have selected the top 100 rows only, there are about 600,000 rows in the dataset.

1. I just need each row in the dataset...

i have attached a sample, it's faster. thanks!

Market basket analysis starts with studying all the items in a single purchase/order by a customer. And that's the first thing I'm trying to do with this dataset.

The maximum number...