Rich Yarger (2/15/2011)

---

Blaaaaaaaaaaaaaaaaaaaaaaaaaaah. . .Columns - not data. 🙁

DECLARE @XML xml;

SET @XML ='

<Root>

<Customer ID="1" FirstName="John" LastName="Doe" Street="123, Fake Street" City="Anytown" State="NY" Zip="11280" HomePhone="555-123-4567"

...

</Transactions>

</Checking>

</Accounts>

</Customer>

</Root>'

SELECT

...

You're welcome. 🙂

(I just got a little confused since you used it correctly before... I didn't wanted to come...

... like the example Mister...

Craig Farrell (2/15/2011)

---

Hey Lutz and Magoo?

I'll admit my XQuery is very weak. One of the things that's always confused me is this part:

FROM

@XML.nodes ('/ROOT/Customer') as cust(cn)

cross apply...

MM

using your very fine example I'd suggest using CROSS APPLY instead of "climbing up" the nodes level.

Just compare execution plan and query statistics... (on a larger set of data, of...

Craig Farrell (2/15/2011)

---

LutzM (2/15/2011)

---

Wouldn't index 1 be used if...

Wouldn't index 1 be used if a query would...

Please read my reply completely.

The query I posted may perform really bad. Hence my advice to add the computed column.

You could use

SELECT *

FROM table_A A

INNER JOIN table_B B

ON B.StkNumber LIKE '%'+A.StkNumber

However, this will cause a table scan since there is no index the query...

GSquared (2/15/2011)

---

Any place where you need to dynamically run against objects in the database or server, or call a stored procedure over and over vs a dataset, when the results...

Bad news first: No, there is no wizard.

Now the good news: please have a look at the CrossTab article referenced in my signature. It'll show you how to do it...

did you try a google search?

The keywords "restore from TDE database backup" returned several useful links, including this one.

SSC - your Simple Search Community.

Dave Ballantyne (2/15/2011)

---

Big meeting on friday to best decide how to handover all my knowledge to co-workers.

First big change i need to do today is was told to make the...

It's hard for us to provide you a script that would...

Something like this?

SELECT

customer.value ('@CustomerID', 'int') AS CustomerID,

customer.value ('@FirstName', 'nvarchar(20)') AS CustomerFirstName,

...