andreiromulus Answered 2 Years ago through
Quizzes
select distinct
a.BloggerId,
MAX(a.BloggerName) as BloggerName,
MAX(a.BlogUrl) as BlogUrl
from (
select t.c.value(N'@bloggerId', N'int') AS BloggerId , t.c.value('.', 'varchar(max)') as BloggerName ,null as BlogUrl from @x.nod...