Are those questions part of an interview?

Does the query return any result at all when executed using the same query window as...

... especially if the old syntax is lacking the WHERE clause in the given example.... 😉

Wouldn't it be a lot easier to use sp_send_dbmail?

For the @query_attachment_filename parameter, use a xls file extension.

I strongly recommend you immediately remove the obviously real data, unless you have proper authorization from each and every company you've listed!!

Replace the data with obfuscated values.

Edit: to post it...

Back to the original question:

Let's assume the travel ageny will offer cruises as well. How would you include it in the design you have in mind?

What would happen if...

I'm not sure if the method described in Jacobs Blog would be a start for a dynamic shredding solution...

There's also a reference to the related XQuery method

Due to the natural...

Jeff Moden (12/25/2011)

---

I see you've added "mind reading" to your list of skills. That was going to be my next question if I couldn't suss it on my own....

Here's a short example of the table-based version using your original sample data.

CREATE TABLE #tmpXML

(

TmpID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

XmlCol XML

)

INSERT INTO #tmpXML (XmlCol)

VALUES (@XmlData)

CREATE PRIMARY XML INDEX...

One more question:

How large is the XML structure?

It might help to insert the data into a table with an indexed xml column.

Under certain conditions the additional time to create the...

OUTER APPLY is your friend here, too 😀

Please note I decided to use some totally meaningless alias names so you can easily identify the code that's not your original 😎

This...

I'd rather use the good old CrossTab approach as described in the related link in my signature.

It'd not only easier to remember but usually also faster than the PIVOT.

peter 50174 (12/23/2011)

---

What exactly are you struggling with?

Do you already get the data in your VB script? If so, then it shouldn't be a problem to format it using VB....

peter 50174 (12/23/2011)

---

I want the result via the web. This means I'm using a VB.net...

You didn't really use the anchor in your code.

I've added AcctId to the code and assigned it to the anchor variable. Then I included the anchor to reset @PreviousBalance.

DECLARE

...