creating xml and passing it on.

I'm rather new to xml in sql server 2000.
So i searched around for a while, but i can't quite understand how should i
make a stored procedure, that will create xml from a select clause and then
pass it as an input parameter to another stored procedure?
Basically i can't figure out how can i use "for xml" other than stored
procedure resultset. Or it is not possible otherwise?
Thanks in advance,
Martin.XML capabilities in SQL 2000 is limited compared to what is offered in SQL
2005. If you are starting out, spend some time at www.sqlxml.org and you'll
find most answers to your questions there.
Anith