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 - 2006-07-11 : 11:26:19
|
| Mark writes "I have a recordset with a single common field which can be grouped.I would like to return a single record based on the grouped field which contains a varchar or memo field with the data from all the records concatonated into it. Preferably in the form of a view which I can use with other viewsex data:Item PO Site Qty00615 PO00S0924 KP 60000615 PO00F925 WA 24000616 PO00F925 WA 48000616 PO00S0924 KP 240000618 PO00S0924 KP 30000618 PO00F925 WA 60Desired result: Item Orders00615 PO00S0924-KP-600,PO00F925-WA-24000616 PO00F925-WA-480,PO00S0924-KP-240000618 PO00S0924-KP-300,PO00F925-WA-60Thanks,Mark" |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-12 : 02:34:45
|
| Also note that if the concatenated strings exceeds 8000 characters you may need to use more than one variable to have strings. If possible do concatenation at front end applicationMadhivananFailing to plan is Planning to fail |
 |
|
|
haw001
Starting Member
20 Posts |
|
|
|
|
|
Return all records from grouped resultset into single record