--create table #TMP_TABELA (dane1 varchar(10), dane2 varchar(10))
/*
insert into #TMP_TABELA values ('6aaaaa', '6bbbbbb')
insert into #TMP_TABELA values ('5aaaaa', '5bbbbbb')
insert into #TMP_TABELA values ('4aaaaa', '4bbbbbb')
insert into #TMP_TABELA values ('3aaaaa', '3bbbbbb')
insert into #TMP_TABELA values ('2aaaaa', '2bbbbbb')
insert into #TMP_TABELA values ('1aaaaa', '1bbbbbb')
insert into #TMP_TABELA values ('0aaaaa', '0bbbbbb')
insert into #TMP_TABELA values ('7aaaaa', '7bbbbbb')
*/
SELECT
(SELECT dane1, dane2 from #TMP_TABELA
FOR XML RAW('b'), TYPE)
FOR XML RAW('a'), TYPE
potrzebuję uzyskać:
<a>
<b dane1="aaaaa" dane2="bbbbbb" />
</a>
<a>
<b dane1="6aaaaa" dane2="6bbbbbb" />
</a>
<a>
<b dane1="5aaaaa" dane2="5bbbbbb" />
</a>
<a>
<b dane1="4aaaaa" dane2="4bbbbbb" />
</a>
<a>
<b dane1="3aaaaa" dane2="3bbbbbb" />
</a>
<a>
<b dane1="2aaaaa" dane2="2bbbbbb" />
</a>
<a>
<b dane1="1aaaaa" dane2="1bbbbbb" />
</a>
<a>
<b dane1="0aaaaa" dane2="0bbbbbb" />
</a>
<a>
<b dane1="7aaaaa" dane2="7bbbbbb" />
</a>
a mam:
<a>
<b dane1="aaaaa" dane2="bbbbbb" />
<b dane1="6aaaaa" dane2="6bbbbbb" />
<b dane1="5aaaaa" dane2="5bbbbbb" />
<b dane1="4aaaaa" dane2="4bbbbbb" />
<b dane1="3aaaaa" dane2="3bbbbbb" />
<b dane1="2aaaaa" dane2="2bbbbbb" />
<b dane1="1aaaaa" dane2="1bbbbbb" />
<b dane1="0aaaaa" dane2="0bbbbbb" />
<b dane1="7aaaaa" dane2="7bbbbbb" />
</a>