Как написать запрос для представления данных в соответствии с XML

---

< row codedescription= "название банка" val= "ведущий банк-другие" fraudid=" 1 "code= "1001" prelnkbaseid= "1">
&ЛТ;codedescription строки="количество мошенничества" вал="" fraudid="1" код="1002" prelnkbaseid="1"&ГТ;
&ЛТ;подряд codedescription="реквизиты филиала" вал="" fraudid="1" код="1003" prelnkbaseid="1"&ГТ;
< row codedescription="(a) код ветви * * "val=" 0220001 " fraudid=" 1 "code= "1004" prelnkbaseid= "1">
< row codedescription="(b) название ветви * * " val=" GUWAHATI " fraudid=" 1 "code= "1005" prelnkbaseid= "1">
< row codedescription= "имя преступника * *" val= "тест" fraudid=" 1 "code=" 1006 "prelnkbaseid= "1">
< row codedescription= "имя учетной записи * *" val= "test2" fraudid=" 1 "code= "1007" prelnkbaseid= "1">
< row codedescription= "название деятельности преступника * *" val= "test3" fraudid= " 1 "code= "1008" prelnkbaseid= "1">
< row codedescription= "PAN of Criminal * *" val=" test4 " fraudid=" 1 "code= "1009" prelnkbaseid= "1">
< row codedescription= "область операции, где произошло мошенничество * * "val=" авансы-счета "fraudid=" 1 "code= "1010" prelnkbaseid= "1">

это xml-данные...
имя таблицы - - - - frauddetails
наименование---наименование кол преступника ,имя учетной записи,имя действия виновного,FraudID,

Что я уже пробовал:

Вставить в #FMR1XBRL (XBRLCode, PerLnkBaseId ,FraudID, circle, fraudno ,brcode , branchid ,principalparty ,name_of_account ,Name_of_perpetrator, Pan_perpetrator ,fraudarea ,
frdinBorrAcct, consortium_advance, Name_consortium_lead_bank, consortium_leader_amount ,fraudnature, Type_of_fraud ,ComputerUseYN ,ComputerDesc, totalamountinvolved ,Amount_frozen ,
occurencedate, detectiondate ,frauddetectiondelayrsn ,rbireportingdt ,rbireportingdelayreason, How_fraud_detected, BriefHistory ,modusoperandidetails ,frdstaffinvolved ,frdcustomerinvolved ,
frdoutsiderinvolved, frddetectedbyRoZo, Improvementreqdinsystem, AuditdoneaftFrd, WhyfrdnotdetectedinAudit, ActionfrnondetectioninAudit, FIRlodged ,Policestation, FIRDate ,PoliceinvestigationStatus ,
Investigationcompletiondt, Investigationsubmissiondt,FIRNotlodgingreason ,SuitFilingdate, Suitfilingposition ,InsuranceClaimLodged, ReasonfornotLodgingInsuranceClaim ,InternalInvestigationproposed ,InternalInvestigationcompdate, departmentalenquiryprop ,
StepstoAviodIncidence, totalamountrecovered, Amtrecoveredfrmparty ,amtrecoveredfrminsurance , amtrecoveredfrmothsource ,extentoflosstobank ,provisionheld ,amountwritenoff ,SuggestionforRBI,wheatherCase_closebyRbi, RptDate )


select (ROW_NUMBER () OVER (PARTITION BY 2 Order by fraudkid))+1000, 1 as PerLnkBaseId, fraudkid, circle, fraudno ,brcode , branchid ,principalparty ,name_of_account ,Name_of_perpetrator ,Pan_perpetrator ,fraudarea ,
frdinBorrAcct, consortium_advance, Name_consortium_lead_bank, consortium_leader_amount ,fraudnature, Type_of_fraud ,ComputerUseYN ,ComputerDesc ,fraudamount, Amount_frozen ,
occurencedate, detectiondate ,frauddetectiondelayrsn ,rbireportingdt ,rbireportingdelayreason, How_fraud_detected, BriefHistory ,modusoperandidetails ,frdstaffinvolved ,frdcustomerinvolved ,
frdoutsiderinvolved, frddetectedbyRoZo, Improvementreqdinsystem, AuditdoneaftFrd, WhyfrdnotdetectedinAudit, ActionfrnondetectioninAudit, FIRlodged ,Policestation, FIRDate ,PoliceinvestigationStatus ,
Investigationcompletiondt, Investigationsubmissiondt,FIRNotlodgingreason ,SuitFilingdate, Suitfilingposition ,InsuranceClaimLodged, ReasonfornotLodgingInsuranceClaim ,InternalInvestigationproposed ,InternalInvestigationcompdate, departmentalenquiryprop ,
StepstoAviodIncidence, totalamountrecovered, Amtrecoveredfrmparty ,amtrecoveredfrminsurance , amtrecoveredfrmothsource ,extentoflosstobank ,provisionheld ,amountwritenoff ,SuggestionforRBI, wheatherCase_closebyRbi, RptDate
от frauddetails

---