Check if this thread http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads?page=4 can be of help.

>Hi
>
>I have a table of sales with a field ID and a field Itens XML Data Type like
>

>  OrcamentoItens
>  Produto
>    ProdID 100399/ProdID
>    Qtd 2 /Qtd
>    ValorU 12.80 /ValorU
>    Obs /
>    Grade P/01 M/01 G/0 /Grade
>  /Produto
>  Produto
>    ProdID 101548 /ProdID
>    Qtd 1 /Qtd
>    ValorU 18.60 /ValorU
>    Obs /
>    Grade P/0 M/0 G/01 GG/0 /Grade
>  /Produto
>/OrcamentoItens
>
>

>I´d like to have the sum of Qtd*ValorU grouped by id. How to use XQuery to get this result?
>
>Thanks