Convert Some Data To XML

Hi all,
I have some data that I want to pass to a proc using an XML parameter.

Data looks like this:

ElementName | ElementType
=================
Jim | Male
Henry | Male
Sarah | Female

I want the XML to look like this:




Code Block
<Elements>
<Element>
<ElementName>Jim</ElementName>
<ElementType>Male</ElementType>
</Element>
<Element>
<ElementName>Henry</ElementName>
<ElementType>Male</ElementType>
</Element>
<Element>
<ElementName>Sarah</ElementName>
<ElementType>Female</ElementType>
</Element>
</Elements>






Is that possible using T-SQL? Any help would be much apreciated.

Regards
Jamie