|
Posted by Simon Hayes on 05/27/05 20:15
<chudson007@hotmail.com> wrote in message
news:1117191730.138398.189500@f14g2000cwb.googlegroups.com...
I'm not sure how to go about this and need some help.
I've got a data extract rather than a properly structure table in SQL.
It looks something like below:
Name: Item:
John Ball
John Racket
Paul Ball
Jim Glove
Jim Ball
What sort of script can I run that will return each name once and then
the Items in as many columns needed to list them all?
I.e. so that it will look like
Name: Item1 Item2
John Ball Racket
Paul Ball
Jim Glove Ball
Regards,
Ciarαn
The short answer is that this is usually much easier to do in the front end
than in the database; for the long answer, Google for "dynamic crosstab
queries", and also see this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;175574
Simon
[Back to original message]
|