Last post Aug 10, 2020 07:40 AM by yij sun
Aug 07, 2020 10:12 PM|mansooraabid|LINK
WITH XMLNAMESPACES(DEFAULT 'http://schemas.datacontract.org/2004/07/myData.SharedData.ViewModels.MyData')
x.inf.value('(Name)','nvarchar(225)') as NAME,
x.inf.value('(Age)','nvarchar(225)') as AGE,
x.inf.value('(Gender)','nvarchar(225)') as GENDER
FROM MYTABLE as t cross apply (select cast(t.TEST_DATA as xml) as BOND_PAYLOAD) as ca
cross apply ca.TEST_DATA.nodes('/WarehouseBondMyDataModel') as x(inf) where t.EmpId in('07302018433486048145')
Aug 10, 2020 07:40 AM|yij sun|LINK
Accroding to your description,I don't understand your reqiurment clearly.What is the meanings of replacing THREE sp charaters in Name,Age column?
Could you post some details or sample table,table data to us?It will help us to solve your problems.