Declare @Stylesheet as XML
Declare @xOutput as XML
DECLARE @XmlTable TABLE (
Element0 int,
Element1 nvarchar(100),
Element2 nvarchar(200))
INSERT INTO @XmlTable ([Element0] ,[Element1],[Element2])
VALUES (1,'bobo','Monkey')
SET @xOutput = (Select *From @XmlTable
FOR XML PATH( 'DataItem' ), ROOT('Root'))
select @xOutput
select @xOutput.query('
<?xml-stylesheet type="text/xsl" href="my-style-sheet.xsl" ?>,/.')
See also:
http://blogs.msdn.com/b/mrorke/archive/2005/05/10/416033.asp[
^]