hi all,

i have one category table in sql-server2000 and i would like to create xml file so child category should come under parent category.

table like this

Id category parentid



1 Handicraft 0

2 Garment 1

3 sarees 2

4 covers 1

5 pillow cover 4

6 decorative items 1

7 Food 0

8 pickles 7

9 mango pickles 8

10 masala 7

11 Chaniya Choli 2

table is like this please anyone can guide me to solve my problem