Pardon me as i am new to this, i think i have attached the .sql file which i think is not admissible format. i am changing the extension to .txt...

HI i have added this into the temp table for the easyness... Let me know in case i may have missed anything. 
However,as i have posted earlier the RecordData is...

Thanks Alan, you are brilliant!!!

HI Alan Thanks for that quick help.

i really appreciated. well, i am actually able to retrieve the data

However, the data is coming with the same token Names for all of...

Thanks

i am not so expert on the XML and i am using the query above. However i am getting a below error definitely, i am missing something here

"Msg 9506,...

Also,dr.dcmnt_rqst_id can be kept as any value.

Here is what i am expecting the result out of the same.

Current Result:

dcmnt_rqst_id token_name ...

Yeah please find it below. note that the entry of the XML is the same which was attached.

create table etl.STG_LETTER_RQST

(

dcmnt_mppng_data_txt nVARCHAR(max)

)

insert into etl.STG_LETTER_RQST

select N'<?xml version="1.0" encoding="UTF-8"?> <template-data-map xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.crsoftwareinc.com/xml/ns/titanium/document/v1_0"><entity-descriptor...