Hi, you need to reference a value to the inner most hierarchy level and go up from there to reference elements from higher hierarchies.

Example (note: I copied your xml structure...

Vijaya Kadiyala (4/14/2009)

---

There are so many ways to write a script.

Couple of points:

1) What if the table names are not same ex: DEPT,EMP,LOCATION etc.

2) What if the table names are...

Hi Vasco,

I disagree with Vijaya's statement:.

Reason:

Assuming the tables to be modified are as provided...

Hi,

would you please be a little more specific on what you're trying to do?

Do you want to add values to the same (existing) columns or do you want to alter...

Here's the link:

http://www.sqlservercentral.com/Forums/FindPost695508.aspx

Edit: link added to url.

Alvin Ramard (4/13/2009)

---

Bob Hovious (4/13/2009)

---

It's not a big deal, Steve. Folks have been referring to Flo as "she/her". I swapped a few cordial posts...

Hi,

As per BOL (search "wildcard characters [SQL Server]"):

C. Using the ESCAPE clause

The following example uses the ESCAPE clause and the escape character to find the exact character string 10-15% in...

Hello Hans,

If I'm getting you right you're asking for a tool that will take the nodes and create tables based on that and fill those tables with the columns with...

Hi,

if the columns you want to change your rows to are always the same and you're I'd recommend to use the PIVOT function.

If you need dynamic columns you should...

Hi,

I'm not sure whether you figured it out already or not...

the reason for failure is that your declaration is missing a local namespace definition.

If you add

...

Hi Matthias,

I'm sorry for not responding earlier but I just returned from a weekend trip.

The only modification I can see with SS2K5 is the replacement of the temp table...

If that's the case, isn't it exactly what the code I...

@Barry:

Since your table #r is similar to table #t2 in my previous post I'm wondering if there is an even easier solution than mine to get the output the OP...

Maybe this solution is a little easier to expand to 10 columns...

What needs to be done is to add one SELECT statement to #t1 and two more CASE per addtl....

Did you look into application roles?

Brian Kelley's article below pretty much describes your scenario. Maybe it's an option, even with all the con's...

http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/