Find Jobs
Hire Freelancers

Transact-sql function to extract XML Differences

$30-250 USD

Completed
Posted about 3 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 29457051

About the project

6 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$0 USD in 1 day
5.0 (1 review)
1.0
1.0
6 freelancers are bidding on average $141 USD for this job
User Avatar
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 about the project. Best Regards Fouad
$240 USD in 3 days
5.0 (16 reviews)
4.9
4.9
User Avatar
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 already inserted. If matched then insert else not. 4) convert table back to xml with no duplicate tag Kindly message let me know if you need to know more info regarding my approach. Thanks
$135 USD in 3 days
5.0 (10 reviews)
4.2
4.2
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Logan, United States
5.0
15
Payment method verified
Member since Sep 12, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.