Doing a join between XML data typed field and a relational table in Yukon (SQL 2005)

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Nitsan (nitsan.shaked_at_intel.com)
Date: 07/12/04 

Date: 12 Jul 2004 04:00:35 -0700

Hello,

I have a Yukon XML question and would be very happy if someone can
assist:

Let's assume I have 2 tables:

One will be product table – Regular relational table with Product ID
as a primary key and some descriptive fields.

Second is an Order table – it has Order ID as a PK and Order details
which is a field of XML data type and holds all lines in the order
including quantity, product id, prices, etc.

I want to make a join that will present the orders with all product
details for each order line.

Do you know how can I do a Join between XML field and relational
table?

Thanks,
Nitsan

Relevant Pages

  • Doing a join between XML data typed field and a relational table in Yukon (SQL 2005)
    ... I have a Yukon XML question and would be very happy if someone can ... Second is an Order table – it has Order ID as a PK and Order details ... including quantity, product id, prices, etc. ...
    (microsoft.public.sqlserver.programming)
  • How to save FOR XML results into TEXT column?
    ... It appears that the FOR XML clause doesn't 100% get done what I ... need to accommplish. ... Problem: With Orders table (no Order Details) as: ...
    (microsoft.public.sqlserver.xml)
  • RE: Formatting XML in Excel?
    ... Do you mean XML or XLSM. ... They are completely different type files. ... one side of an order and in rows C-F I had the associated order details; ...
    (microsoft.public.excel.misc)
  • RE: Optimizing size of generated XML
    ... For customizing the serizlized xml content of our classes, we can use xmlserizliation attributes to adjust our classes. ... you can try modify your ProductPriceGroup class's defintion as below: ... \par public class ProductPriceGroup ... \par which will make the serilized xml of ProductPriceGroup's Prices[] property without the wrapper element. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: design choice: multi-threaded / asynchronous wxpython client?
    ... actual starting prices at post time x minutes in the future). ... I can quickly retrieve the relevant last n tote data samples ... If instead of storing XML and YAML you store the data points, ...
    (comp.lang.python)