What if I have to get all request in seperate rows for each request

I have send you whole xml in private message check it out

Its a very long xml and its output is also long that I cant post whole xml here.

That is why I have posted some of it here with the query.

Can...

I Have made this query

SELECT

CAST((R.[XMLData].query('/Record/Body/Insert/Request/Column/ColumnName/text()')) as varchar(8000)) as TableInfo

FROM ESRequestInfo AS [R]

But it is getting the result like this....

AppPolicyDescEmpCatEmpIDEmpNameAppTopicCodeAppTopicDescAppEmpObjNoAppEmpObjDescAppEmpObjTargetDateAppEmpObjTargetValueAppEmpObjMarksAppEmpObjCommentsAppEmpObjMeasureIndicatorAppFormTypeWeightageCreatedByCreatedOnLastUserLastUpdateAppPolicyDescEmpCatEmpIDEmpNameAppTopicCodeAppTopicDescAppEmpObjNoAppEmpObjDescAppEmpObjTargetDateAppEmpObjTargetValueAppEmpObjMarksAppEmpObjCommentsAppEmpObjMeasureIndicatorAppFormTypeWeightageCreatedByCreatedOnLastUserLastUpdateAppPolicyDescEmpCatEmpIDEmpNameAppTopicCodeAppTopicDescAppEmpObjNoAppEmpObjDescAppEmpObjTargetDateAppEmpObjTargetValueAppEmpObjMarksAppEmpObjCommentsAppEmpObjMeasureIndicatorAppFormTypeWeightageCreatedByCreatedOnLastUserLastUpdate