使用XML将XML字符串作为值传递

I am new to XML (in SQL) and was asked to create a Stored Procedure that would pass an XML string to a field on a different server. I am able to get the XML string using the FOR XML RAW, however I get 1 row with all records and unable to only return the individual row data. I need to have result return 100 rows if my query has 100 rows, right now I get 1 row with all records. How can I get the XML string to only include the row data only and not the entire string for all rows? I am new to XML (in SQL) and was asked to creat