select
    Product.ProductCode,
    (
    select
        Price.QuantityX,
        Price.QuantityY,
        Price.Price
    from
        Genesis.ProductPriceGrid2D as Price
    where
        Product.ProductCode = Price.ProductCode
    for xml auto, Type
    )
from
    Genesis.ProductPriceGrid2D as Product
group by
    Product.ProductCode
for xml auto, root('Products')