I'm getting the same result for all the 4 queries posted.

anybody else?

Bob Hovious (8/14/2009)

---

Lucky, could you show us some sample data and then the expected output? I'm not sure I understand your question from what you put in the...

GSquared (3/24/2009)

---

Your query is using "nodes()" on "productRef", but there's only one productRef in your XML sample.

I've attached a query that will get the second result you want. The...

Hello ozkary,

Thanks for the reply.

This is exactly what I've done before posting to the forum but somehow it is giving odd results. Every line matches to the one you posted.

I'll...

Ramesh (2/15/2009)

---

First, I would like to know why would you need to have a separate tables for the same entity? From this, may be we can help you eliminate...

lucky (1/23/2009)

---

CozyRoc (1/23/2009)

---

lucky (1/23/2009)

---

CozyRoc (1/23/2009)

---

lucky (1/22/2009)

---

Thanks Ray for...

CozyRoc (1/23/2009)

---

lucky (1/23/2009)

---

CozyRoc (1/23/2009)

---

lucky (1/22/2009)

---

Thanks Ray for replying...

CozyRoc (1/23/2009)

---

lucky (1/22/2009)

---

Thanks Ray for replying back.

As mentioned...

Thanks Ray for replying back.

As mentioned in my...

Thanks to everyone who helped.

Hello Lynn,

The job is running under a domain account which is existing on both the source and the destination servers...

Mas (4/24/2008)

---

Hi there-

I hope I have the correct forum. I need to find a way to delete the data rows from my Excel template. I have a workbook formatted to...

Ratheesh.K.Nair (4/24/2008)

---

Hi All,

I got this error when i tried to attach adventureworks DB.Am having SQL Server Developer Edition with SP2...

Marios Philippopoulos (4/17/2008)

---

I'm getting the following error while using OPENROWSET:

OLE DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399)...

Have you evaluated your expressions so that you can verify the exact path it is trying to hit.