For XML Path

Select StamTableId,

Cast( ( Select StamTableStr, StamTableText

From StamTable T1

Where T1.StamTableId=T.StamTableId

For XML Path('Stam')

) As XML

) SQL

From    StamTable T

http://msdn.microsoft.com/en-us/library/ms190922.aspx

http://vstoolsforum.com/blogs/sqlserver/archive/2008/08/26/for-xml-path.aspx

http://blog.sqlauthority.com/2009/02/12/sql-server-simple-example-of-creating-xml-file-using-t-sql/