This example is useful for when you have a fixed maximum number of locations you want to show:

SELECT ItemName, ISNULL(T1.Name,'')  as Practice1, ISNULL(T2.Name,'')  as Practice2, ISNULL(T3.Name,'') as Practice3
FROM Claims LEFT JOIN TaxonomyEntries T1 ON T1.Value + '|' + CAST(T1.ID as nvarchar(max)) = XMLField1.value('(//Data[@DatabaseValue="TextField2"]/@Value)[1]','nvarchar(max)')
LEFT JOIN TaxonomyEntries T2 ON T2.Value + '|' + CAST(T2.ID as nvarchar(max)) = XMLField1.value('(//Data[@DatabaseValue="TextField2"]/@Value)[2]','nvarchar(max)')
LEFT JOIN TaxonomyEntries T3 ON T2.Value + '|' + CAST(T3.ID as nvarchar(max)) = XMLField1.value('(//Data[@DatabaseValue="TextField2"]/@Value)[3]','nvarchar(max)')
WHERE Claims.ID = 11111