Eric, Good suggestion, but its highly inefficient.
Apparently SQL Server 2000 has some functionality to allow you to aggregate column data like that... but beware, its not portable across different RDBMS and I would guess its performance is not so hot. -dhs At 10:16 AM 9/27/01 -0400, [EMAIL PROTECTED] wrote: >The only way I know to get a relational database to output a >comma-delimited list is to use a cursor. >|-------------------+-----------------------------------------------------| >|Eric A. Laney |"We have seen too much success to have become | >|Systems Engineer |obsessed with failure." | >|LAN Optimization | | >|Team | | >|Verizon Data | Lyndon B. Johnson (1908-1973)^Quoted in National| >|Services | Review, 31 December 1963| >|Voice: 813.978.4404| | >|Pager: 888.985.8519| | >| | | >|-------------------+-----------------------------------------------------| > > > > > > > > "Yanik > > Lupien" To: SQL > <[EMAIL PROTECTED]> > <yanikl@visic cc: > > .com> Subject: SQL > List > > > 2001-09-27 > > 09:46 > > Please > > respond > to > > sql > > > > > > > > > >Hi, > >I have a small question. > >This is my table : > >English French >-------- -------- >Dog Chien >Dog Pitou >Cat Chat >Cat Minou >Animal Animal > >I want something like : Select English, XXXX(French) from table group by >English : to get a list of "French" > >English French >-------- -------- >Dog Chien, Pitou >Cat Chat, Minou >Animal Animal > >It is possible ? > >Yanik Lupien > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
