generate nested xml form Country and corresponding states and download

Question

Contry  and state table in sql server has foreign key relationship. How to generate and download country and coresponding states in nested xml format?