, 05 2014 . 22:52
+
!
(
http://hiprog.com/forum/read.php?id_forum=1&id_theme=3972&page=1) VBA:
Public Function UnionStr1(ID, Fam)
Static IDOld, FamUnion
If IDOld <> ID Then
IDOld = ID
FamUnion = Null
End If
FamUnion = (FamUnion + ", ") & Fam
UnionStr1 = FamUnion
End Function
, :
SELECT 1., 1., Last(UnionStr1([],[])) AS , 1., Sum(1.) AS [Sum-]
FROM 1
GROUP BY 1., 1., 1.;
:
| | | . | | | | 0304 | | 001 | 135 | 1 | | 0304 | | 002 | 135 | 1 | | 0304 | | 003 | 135 | 1 | | 0376 | | 765 | 579 | 1 | | 0376 | | 766 | 579 | 1 | | 0376 | | 767 | 579 | 1 |
|
:
| | | . | | | | 0304 | | 001 002 003 | 135 | 3 | | 0376 | | 765 766 767 | 579 | 3 |
|
3-4 !
:
| | | | . | | | | 0304 | | | 001 002 003 | 135 | 3 | | 0376 | | | 765 766 767 | 579 | 3 |
|
, , , .
!
http://www.sql.ru/forum/1081073/konkatenaciya-stolbcov
