with NameList
as
( Select
FName = 'Leo'
Union All
Select
FName = 'Rodrigo'
),NameListTotal
as
( Select
Total = Count(1)
From NameList
)
Select
FName = (SELECT FName + ' ' AS 'data()' FROM NameList FOR XML PATH('')),
Total
From NameListTotalwith NameList
as
( Select
FName = 'Leo'
Union All
Select
FName = 'Rodrigo'
),NameListTotal
as
( Select
Total = Count(1)
From NameList
)
Select
FName = (SELECT FName + ' ' AS 'data()' FROM NameList FOR XML PATH('')),
Total
From NameListTotal