Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement