Craig Farrell (3/30/2011)

---

john.arnott (3/30/2011)

---

Kiara (3/29/2011)

---

I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.

I just spent about 45 minutes...

GilaMonster (3/30/2011)

---

Stefan Krzywicki (3/30/2011)

---

GilaMonster (3/30/2011)

---

Craig Farrell (3/30/2011)

---

Grant Fritchey (3/30/2011)

---

And that blank spot...

Thanks Jason - I was thinking that, and forgot to put it in there.

You might want to consider adding the schema name to the query that Lutz posted:

SELECT s.name AS schema_name,

t.name AS table_name,

...

A standby database is part of a high-availability set where the database can be brought on-line (relatively) quickly for use.

A read-only database is online, but you cannot perform any write...

Generally speaking, I would go with an iTVF.

For a stored procedure, if it needs to be called for every row in a query, then you have no choice but to...

GilaMonster (3/30/2011)

---

You think it hasn't been...

Well, you MVPs need to stress to MS how confusing this R2 naming scheme is to everyone, and how they need to stop it.

Congrats! Hope I can make it also...

Fal (3/30/2011)

---

Hmm - this could help out quite a bit over here also! 😀

If you can get me a...

steven.hulse (3/29/2011)

---

Thanks for the warm welcome guys! Even though i'm a little aprehensive about taking on this challenge, I am looking forward to it. I strangely found when working with...

Well, you can always use The other Thread. 😀

Great, thanks for the feedback.

Now, please read the first line in my signature, and ask if you have any questions about...

How's this?

;WITH cte AS

(

SELECT [parent] = d.v.value('../@name[1]', 'varchar(50)'),

[child] = d.v.value('@id[1]', 'varchar(50)')

FROM @myXML.nodes('/root/parent/item') AS d(v)

)

SELECT [parent]

FROM cte

WHERE child = '4'