I appriciate your response. And you solution was awesome. Thats what i was looking for.

And I Appriciate you suggetion that I have to reevaluate the table structure but In my...

Thanks for your response.

I figured out it earlier but still i am stuck into how to parse the moreproperties value into the table.

If you shed any lights on it.

Thanks

Below is the Code What i am trying to do.

I am stuck in the parsing the identity value of the parents to child node.

I know that i am doing something...

Below is the Code What i am trying to do.

I am stuck in the parsing the identity value of the parents to child node.

I know that i am doing something...

Garadin,

I appriciate your fast responce.

But in my actual xml file i have name space so in the code i am declaring the name space.

;WITH XMLNAMESPACES(default 'http://schemas.xmlaaaa.org/aaaaenv/envelope/')

so when i am trying...

Thanks,

I appriciate your response.

I already try to find the solution from the Jacob articles and tried different thing.

Let me give shot again.

Below is the Sample XMl file.

Now the problem is how can i give the node name for the property.there were like more than 50 propery in the mail file.and its...

Hey Man,

Thanks alot.

Its working.

But now I got the new file. Its has MoreProperty node under Child.

How can i write query to parse these into SQL server table.

I...

Hey Lutz,

Thanks for you help.

I am using the solution with cross apply for keep identity values in child nodes.

But now i am facing difficuilty because now i am getting XML...

Hi,

I created the .bat file but i need something like ...

If any one click on the batch file ,then i want that it ask for the server name and then...

I wanna create a .cmd file and have to make it simple so non technical person can do it from command line using the installation instructions.

Hey LutzM,

Thanks Alot,,I got it...its working now,,,

Thanks LutzM ,,I figured out that,,in the ParentIDreference I changed it to Parent_ID instead of Individual_ID. After running the code,,2 rows affected in parent table and 0 rows affected in...

I deleted that </Redge> part still its not working.The last updated query which post its don't have that part still i am getting error in loading the child table.

I appriciated your responce. But I never worked with the XML file Before.

I Mentioned the Mains node in the Query "FROM @xml.nodes('Mains/Parents/Parent')".

I don't know u mean to change it like...