Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-01 : 11:54:26
|
Mike Fox writes "When a database is normalised it breaks into multiple tables.
(this we all know)
Can a single query be made to bring back the sub units as a single element f.e.:
Normal Query Result:
> StudentName | Course
> Bob | Calculus 101
> Bob | English 200
> Fred | Biology 300
Better Query Result:
> StudentName | Courses
> Bob | Calculus 101, English 200
> Fred | Biology 300
(The query will be run through ADO to either Access or SQL server 7)" |
|
|
|
|
|
Can you convert row elements into a single element?