Færdiggjort

Transact-sql function to extract XML Differences

We save an XML log file when users update records.

Here is an examples of a change log (xml):

<before>

<ProductID>20000</ProductID>

<Description>Raspberry</Description>

<price>15</price><qty>15</qty>

</before>

<after>

<ProductID>20000</ProductID>

<Description>Raspberry</Description>

<price>18</price>

<qty>12</qty>

</after>

To save space, I want the XML to include only the fields that have changed:

<before>

<price>15</price>

<qty>15</qty>

</before>

<after>

<price>18</price>

<qty>12</qty>

</after>

The <before/> and <after/> tags are constant, however all other fieldnames and values are subject to change.

for example for this INPUT:

<before>

<someRandomField1>100 </someRandomField1>

<someRandomField2>abc</someRandomField2>

<someRandomField3>xyz</someRandomField3>

</before>

<after>

<someRandomField1>100 </someRandomField1>

<someRandomField2>banana</someRandomField2>

</after>

Would result in this OUTPUT:

<before>

<someRandomField2>abc</someRandomField2>

<someRandomField3>xyz</someRandomField3>

</before>

<after>

<someRandomField2>banana</someRandomField2>

</after>

Procedure or Function should be writtin in Transact-SQL and not reference any DLL's or assemblies.

Evner: XML, SQL, T-SQL (Transact Structures Query Language), XSLT, Database Administration

Se mere: sql charts flash xml, extract xml database php, sql server export xml, extract xml file vbnet, extract xml files website, extract xml flash site, php extract xml data, sql server insert xml database, convert procedure function sql mssql oracle, sql server dump xml, crystal reports extract xml nodes, sql code extract xls file, extract xml site, sql server insert xml file database, extract xml flex function, database function extract data xml file

Om arbejdsgiveren:
( 12 bedømmelser ) Logan, United States

Projekt ID: #29457051

Tildelt til:

(0 bedømmelser)
0.0

7 freelancere byder i gennemsnit $149 timen for dette job

Proolancer

Hello, I m a web and desktop developer with 10 years of experience in C# ,I did many management web system during my professional life, I can do what you want in the deadline just contact me and we can discuss more abo Flere

$240 USD in 3 dage
(11 bedømmelser)
4.6
awaissheikh151

Hi, The tsql function will be created in following manner. 1) Full xml will be passed as function parameter. 2)Add one tag at a time in a temptable. 3) before inserting tag check binary checksum with table values alre Flere

$135 USD in 3 dage
(8 bedømmelser)
4.1
RushService

Feel fee to contact me for Transact-sql function to extract XML Differences .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the client Flere

$150 USD in 3 dage
(6 bedømmelser)
3.5
spx2

Hi ! I can help you with your project related to the difference-calculating function in Transact-SQL . A broad overview of the services I offer is available here [login to view URL] Best regards, St Flere

$140 USD in 3 dage
(1 bedømmelse)
1.0
izyltony966

Hi, I can efficiently handle your assignment. I am computer programmer with proficient skills in SQL and Database programming. Please inbox

$200 USD in 6 dage
(0 bedømmelser)
0.0
aliashraf92

I can write this transact sql statment. It will definitely write pure sql statement. If you are interested let me know. Regards Ali

$150 USD in 2 dage
(0 bedømmelser)
0.0