Quick solution, more a POC than anything else.

😎

USE tempdb;

GO

DECLARE @TSTR NVARCHAR(200) = N'<TV<MR1#4.0#true#2.0#USD>VT>,<TV<MR2#3.0#true#1.5#USD>VT>,<TV<MR3#0.0#true#0.0#USD>VT>,<TV<MR4#0.375#true#0.19#USD>VT>';

DECLARE @SQL_STR NVARCHAR(MAX) = N''

SELECT @SQL_STR = N'select [Model Code],[Persentage],[isAbs],[AppliedValue],[Currency] from (values '

+ REPLACE(REPLACE(REPLACE(@TSTR,N'<TV<',N'('''),N'>VT>',N''')'),N'#',N''',''') + N') as X([Model Code],[Persentage],[isAbs],[AppliedValue],[Currency]);';

EXEC (@SQL_STR);

Results

Model Code Persentage isAbs AppliedValue Currency

---------- ---------- ----- ------------ --------

MR1 4.0 true 2.0 USD

MR2 3.0 true 1.5 USD

MR3 0.0 true 0.0 USD

MR4 0.375 true 0.19 USD