Exporting multilevel XML from MS SQL 7.0

Hi

Does anyone have any suggestions on how to export data from a MS SQL 7.0 in multilevel XML?

The rs.save only allows a single level!

Cheers

/Bo