Getting Started with Adobe After Effects - Part 6: Motion Blur
Ask
Ask questions, discuss or help others by answering
Related Posts · View All
SQL Server 146
TSQL 76
SSRS 71
SSIS 68
XML 57

Top Categories · View All
SQL Server 146
TSQL 76
SSRS 71
SSIS 68
XML 57

Compare 2 Xml complex file data in SQL Store procedure

Jul 22 2014 12:00AM by Nirav Gandhi   

I have 2 xml files now i want to Compare 2 Xml complex file data are same or not.


Please help it's urgent.

Submitted under: Microsoft SQL Server · XML · XQUERY ·  · 


Nirav Gandhi
38 · 5% · 1567

4 Replies

  • I once wrote a TSQL function that compares two XML files. Please see this post which may be helpful. The code in the above post was created for experimental purpose and I have not used it in any production environment. The performance may be terrible :)

    commented on Jul 23 2014 12:27AM
    Jacob Sebastian
    1 · 100% · 32235
  • Yes but i need procedure who compare each child level and also show which data is wrong.

    commented on Jul 23 2014 4:13AM
    Nirav Gandhi
    38 · 5% · 1567
  • if you want to compare whole xml then you can calculate and compare the checksum of both files.. or if you want to compare values of particular nodes or attribute then you can use xquery to compare both...

    Thanks, Saurabh

    commented on Jul 23 2014 5:19AM
    Saurabh bhadauria
    1313 · 0% · 19
  • Input File looks like below..Starts at row7 Columns are fixed. Rows are not fixed For every quarter months, we have both Avg and Period values and for non-quarter months, we have value only for Avg

        Avg	Avg	Avg	Avg	Avg	Avg	Period	Period
    CCI 1/31/2014	02/28/2014	03/31/2014	04/30/2014	05/31/2014	06/30/2014	03/31/2014	06/30/2014
    AA  3.67	3.67	3.67	3.67	3.67	3.67	3.73	3.97
    AB  8.40	8.40	8.40	8.40	8.40	8.40	8.95	6.95
    

    Output should be like thiis

    CCI Type	Date	Value
    AA  Avg	        1/31/2014	3.67
    AA  Period	1/31/2014	0
    AA  Avg	        2/28/2014	3.67
    AA  Period	2/28/2014	0
    AA  Avg	        3/31/2014	3.67
    AA  Period	3/31/2014	3.73
    AA  Avg	4/30/2014	3.67
    AA  Period	4/30/2014	0
    AA  Avg	5/31/2014	3.67
    AA  Period	5/31/2014	0
    AA  Avg	6/30/2014	3.67
    AA  Period	6/30/2014	3.97
    AB  Avg	1/31/2014	8.40
    AB  Period	1/31/2014	0
    AB  Avg	2/28/2014	8.40
    AB  Period	2/28/2014	0
    AB  Avg	3/31/2014	8.40
    AB  Period	3/31/2014	8.95
    AB  Avg	4/30/2014	8.40
    AB  Period	4/30/2014	0
    AB  Avg	5/31/2014	8.40
    AB  Period	5/31/2014	0
    AB  Avg	6/30/2014	8.40
    AB  Period	6/30/2014	6.95
    
    commented on Jul 26 2014 12:53AM
    divyapillai02
    1807 · 0% · 11

Your Reply


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]