C-Sharp (C#) Group: Sql Query

Hello All

 

I understand this is a C# group. But would like to give it shot

 

 

I have two Table Employee and Dept

Employee Columns
EmpID
EmpName
MgrID
DeptID

EmpID(PK)  MgrID (FK)

Dept COlumns

DeptID
DeptName

I need to return XMl Hierarchy when I pass DeptID as a parameter
So my final result shoudl look like this

<;Dept>
&nbsp;  <Emp ID="&quot; Name=";" .....>
  ; &nbsp; &nbsp; &nbsp; <Emp ID="&quot; Name=";">
 &nbsp; &nbsp; &nbsp; &nbsp;  </Emp&gt;
 &nbsp;  </Emp&gt;
 &nbsp;  <Emp ID="&quot; Name=";">
 &nbsp; &nbsp; </Emp&gt;
<Emp ID="&quot; Name=";">
 &nbsp; &nbsp; &nbsp; &nbsp;  </Emp&gt;
</Dept>

How do I write this Query

Regards