the .value uses xpath to extract the value out of the XML. Since you already have it working using dynamic SQL just put the dynamic SQL into a Table Valued Function and call that via the view.