select
distinct
TRY_CAST(a1.group
as
varchar(max))
as group,
substring((select
distinct
', '+try_cast(a2.delimited
field
as
varchar(max))
from
table_name as a2
where
try_cast(a2.group
as
varchar(max))
=
try_cast(a1.group
as
varchar(max))
order
by
', '+try_cast(a2.delimited
field
as
varchar(max))
for
xml
path('')),2,8000)
as AliasFx
from
table name a1
group
by
cube(a1.group)
order
by 1,
AliasFx
No comments:
Post a Comment