<HMS xmlns="
http://tempuri.org/HMS.xsd">
<Department> /// table name
<DepartmentId>DP0001</DepartmentId> /// <fieldname>value</fieldname>
<DepartmentName>Eye</DepartmentName>
<DepartmentStatus>0</DepartmentStatus>
</Department>
<Department>
<DepartmentId>DP0002</DepartmentId>
<DepartmentName>Nose</DepartmentName>
<DepartmentStatus>1</DepartmentStatus>
</Department>
</HMS>
-----------------------------------------------
I want a stored procedure to insert the data.
Thanks
ZAMI