Dynamic Pivot - Test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bonjour

Joomla

Q&A for Joomla! administrators, users, developers and designers

DECLARE @MyXML XML
SET @MyXML = '<SampleXML>
<Colors>
<Color1>White</Color1>
<Color2>Blue</Color2>
<Color3>Black</Color3>
<Color4 Special="Light">Green</Color4>
<Color5>Red</Color5>
</Colors>
<Fruits>
<Fruits1>Apple</Fruits1>
<Fruits2>Pineapple</Fruits2>
<Fruits3>Grapes</Fruits3>
<Fruits4>Melon</Fruits4>
</Fruits>
</SampleXML>'

select @MyXML.value('count(*)', 'int')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results