Microsoft SQL Server forum - displaying a table

Author

displaying a table

chudson007@hotmail.com

2005-05-27, 7:23 am

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=2Ee. so that it will look like
Name: Item1 Item2
John Ball Racket
Paul Ball
Jim Glove Ball

Regards,
Ciar=E1n

Simon Hayes

2005-05-27, 1:23 pm

<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/defaul...kb;en-us;175574

Simon

Sponsored Links