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 |
|
almu_alf
Starting Member
3 Posts |
 Posted - 2007-08-21 : 02:42:22
|
| Hello!!First of all, thank you in advance for helping me!!!My problem is that I have a BBDD with a table like this (in Oracle and in MySql, both) E.g.+---------+-----------+| groupId | serviceId |+---------+-----------+| grup1 | service1 || grup1 | service2 || grup1 | service3 || grup2 | service1 || grup2 | service2 |+---------+-----------+ And I need to do a select o a procedure or something that returns me something like this:+---------+------------------------------------------+| groupId | serviceId |+---------+------------------------------------------+| grup1 | service1, service2, service3 |+---------+------------------------------------------+ Is this possible in any way????Than you very very much.Almu |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-21 : 04:00:26
|
| <<My problem is that I have a BBDD with a table like this (in Oracle and in MySql, both) >>If you dont use SQL Server, then post at relevent forumMadhivananFailing to plan is Planning to fail |
 |
|
|
almu_alf
Starting Member
3 Posts |
Posted - 2007-08-21 : 04:18:48
|
| Sorry! I thought this was a forum about SQL in general no only SQL Sever!!!Ups! I'll look for the right place then!!!Thank you very much!Almu |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-21 : 04:37:57
|
| You can try at www.dbforums.comMadhivananFailing to plan is Planning to fail |
|
|
|
almu_alf
Starting Member
3 Posts |
Posted - 2007-08-21 : 05:14:50
|
| Thank you!!! I'll do it!!! |
|
|
|
|
|
|
HOWTO select several rows in one comma- separated