Removing duplicate rows.

[englishtwit]

Hi - Bit of a newbie to all this. My data looks like follows:
EURODATA Equipment
EURODATA Equipment
EURODATA Stationery (Subscriptions 01/02)
EURODATA Stationery (Subscriptions 01/02)
EURODATA Equipment
EURODATA Computer Services (Couriers 01/02)
EURODATA Computer Services (Couriers 01/02)
EURODATA Computer Services (Couriers 01/02)
EURODATA Computer Services (Couriers 01/02)
EURODATA Computer Services (Couriers 01/02)
EURODATA Computer Services (Couriers 01/02)
EURODATA Computer Services (Couriers 01/02)

What is the select statement to produce a data set that looks like this:

EURODATA Equipment,Stationery (Subscriptions 01/02),Computer Services (Couriers 01/02)

Apologies if this question seems a bit simple, but some of us struggle.

regards

Dom

 

[PruSQLer]

Not sure what you mean. Do you want 1 row returned that contains all possible values in a horizontal format or do you want to return all distinct rows, aka, remove duplicates, like the title of your post says?

 

[englishtwit]

I need all the rows returned in a horizontal format

ie

EURODATA, test1,test2,test3 etc

 

[PruSQLer]

Check out this thread and see if it helps.

thread220-845302

 

[englishtwit]

thanks pru - looks like I might be trying to do something very tricky.

Thanks for the input!