Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
displaying a tableI'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
Post Follow-up to this message
Re: displaying a table<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
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
