rows to columns

[VeryGoodGirl]

I have the example data:

A1234 RX9999
A1234 RX8989
A1234 RX1234
A5674 RX2
A5674 RX999

I need like:

A1234 RX9999 RX8989 RX1234
A5674 RX2 RX999


All fields are dynamic. Does anyone know how to pivot this in a query? I have done it with a procedure and a temporary table, but that seems like so much overhead.

Thank you!

 

[ptheriault]

Check out this FAQ. It should be what you are looking for.

faq183-2146

- Paul
- If at first you don't succeed, find out if the loser gets anything.