Could you please provide some sample data to test against together with your current query?

For details on how to do it please follow the link in my signature.

Maybe you don't provide the value 'ALL' for the @office parameter when calling the procedure? Edit: not relevant. I missed the END ELSE BEGIN section of the code.

Other than that...

Regarding your first question:

AFAIK, it's not possible to pass a table to a SP in SS2K5. It's a different story in SS2K8...

Other options to deal with such a problem is...

It looks like there's an issue with the way you format the xml data.

Maybe the following combination can be used to get the right format:

FOR XML RAW('item'),ROOT('items'), ELEMENTS, TYPE.

For details...

There's no reason to be sorry.

It's just a new information that you're trying to import from a file. 😉

Your initial post fills the xml variable using a select statement based...

Would you please be a little more specific on how you convert the xml data?

What I'd like to know is

a) Where do you get the xml data from (select statement...

Hi Michael,

Short answer to your question

: It depends.

There is a difference between an attribute (like SampleGroupID is an attribute of the item element...

What is your expected output?

Could you use XQuery instead of openxml?

If yes, here's a simple example on how to query the @id attribute as well as the status element.

If you...

Well, we're getting closer...

Next thing I'd like to see is a DDL statement (table definition) as well as sample data in a ready to use format as described in the...

Instead of using the datepart function you might want to play around with "select dateadd(wk, datediff(wk, 0, @ThisDate), 0)". This will give you the date of Monday from @ThisDate.

Please...

Since you require dynamic column names you might want to look into dynamic cross tabs.

For details please see Jeff's article[/url].

Note: if there are no ready to use data available I...

I still have to recommend you're trying to provide sample data that do reflect your situation.

Let me repeat my recommendation from earlier in this thread:

In order to give you an...

RV (8/24/2009)

---

My purpose is to flatten the XML as table with rows and columns. In my sample xml above all the nodes "name" will be treated as columns and node...

Assuming you're trying to work with more than just a few rows per table (or more than one table) I'd consider keywords like CURSOR or WHILE as being a time...

I think you should take the time to provide some SQL code to explain what you're looking for (including expected result). Please see the link in my signature on how...