This is my query select distinct ItemId,X.Y.value('./@Name', 'VARCHAR(200)') from ItemExt e CROSS APPLY e.ItemCustomPropertyXmlData.nodes('ExtendedProperties/Property') as X(Y) where cast(ItemCustomPropertyXmlData as xml).exist('/ExtendedProperties/Property[@Name eq "'+X.Y.value('./@Name', 'VARCHAR(200)')+'"]') = 1 After executing above query getting "The argument 1 of the XML data type method "exist" must be a string literal" error
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)