How can I read value from one XML and assign to another XML.

I need to read value from one master XML and assign to another XML.

I am planning to move some of my application's business logic to SQL Server side.

I have informations stored in xml field. There is a procedure which accepts the xml input, and return the xml with values from the master xml. Please help me to achieve this.

-- master XML

declare @.x_master xml

set @.x_master='<ROOT><NAME>111</NAME><ADDRESS>2222</ADDRESS><TYPE>3333</TYPE><COUNTRY/></ROOT>'

-- input XML (this can be any tag from the master XML)

declare @.x xml

set @.x='<ROOT><NAME></NAME><ADDRESS/></ROOT>'

--set @.x='<ROOT><NAME/><COUNTRY/></ROOT>'

--set @.x='<ROOT><ADDRESS/><COUNTRY/><TYPE/></ROOT>'

It sounds like you want to interpret <ROOT><NAME></NAME><ADDRESS/></ROOT> as a query. You could generate XQuery by concatenating strings together. You could insert path expressions into the context of <NAME></NAME>. But you need to make sure it is safe from SQL injection since you will be dynamically constructing SQL/XQuery using string concatenation.

sql

how can i install SQL 2005 reporting services in XP Home

Hi,

I have windows XP home with SP2. i am planning to work with sql 2005 reporting services. when i am doing so it is asking me to install IIS. but IIS will now support to XP home edition.

SO is it mandatory for SQL 2005 reporting services need to have IIS. Plz let me know can i install SQL 2005 expression edition with reporting services

Thanks

DK

Reporting Services requires IIS and IIS is not part of XP Home.

You need tp update your OS...

|||

UseSQL Server 2005 Express Edition with Advanced Services

http://msdn2.microsoft.com/en-us/express/aa718379.aspx

you are limited to data out of this DB only but it is a good exercise.

If you have lots of memory, install virtual PC with win 2003 in it to test all your services.