Is it possible to use EXEC() inside OPENXML() ?
I have an XML for each order number. I want to output few parameters from XML by using SELECT. I will outputting other fields also which are in the database and not XML.
SO my output should have fields from database and from XML