Microsoft sql 2012 declob an xml into normalize tables

Requirements Declobbing 2 xml into normalized table • There are 2 types of xml (HCFAClaim) and (UB92Claim) • NO all the xml has the same tag /value • No all xml has all tags • if it fails an xml we should have log into a table for further debug and skip and keep processing • Each segment should have their own sp. And a master sp that call all the sp Sample; Process_xml_sp () should have (call patient_p call insurance_sp call servie_sp)etc.. Here is the desing of the table what we think is correct. Validate and your input is very valuable , review once I need the ddl first then the sp’s also we have to create 5 views but we still desiding You can start DDL and SP for now . keep in separate files