0
i wonder if it is possible to select in an XML bringing all possible results within select and stored in a variable
XML:
<Nome>@PartyId</Nome><Nome>@CallId</Nome>
The tag <Nome>
will always come, but I need to store all the values that come within these tags by concatenating them into a variable like this :
DECLARE X VARCHAR(MAX)
SET X = '@PartyId @CallId'
yes is possible using
nodes
to filter– Ricardo Pontual
could you give me some example please ? @Ricardopunctual
– Igor