Convert a table to XML based on column records in MSSQL

I have a Table that contains directory path some what like this

id  ParentId    Path                            type       Desc
1    -1         Root                              0         a
2     1         Root/Folder1                      0         b
3     1         Root/Folder2                      0         c
4     2         Root/Folder1/abc.dox              1         d 
5     3         Root/Folder2/pqr.doc              1         e
6     1         Root/folder3                      0         f
7     6         Root/Folder3/asd.doc              1         g

I want to create xml like this

<Root>
    <Folder1 id="2" desc="b"/>
        <abc id="4" desc="d"/>
    <Folder2 id="3" desc="3"/>
        <pqr id="5" desc="e"/>
 .
 .
 .
</Root>

There are around 1000 records and hierarchy is not fixed type indicates 0 - for folder and 1 -for file