Hi,
can anyone suggest me in doing the transformation from xml to xsl

i have a column in my DB which is of xml datatype.
for eg this is my xml content in the column.

<Team name="Braves">
<Players>
<Pitcher name="John Smoltz" role="Closer" />
</Players>
</Team>


i need to select this xml column and do the transformation .
direct tranformation from xml to xslt is fine,i require how to select
from the sql and pass it

thanks in advance
Rajesh

Rajesh,
SQL Server does not support XSL transformation from TSQL. If that is the
requirement, you should try SSIS or other components that can perform the
transformation after reading XML data from SQL Server.

If you want to extract specific values from the XML document, you can do it
in TSQL using XQuery methods supported by the XML data type. If the
transformation requirements are simple, you can easily do it 'by coding'
(not with an XSL) in TSQL. For example, you can retrieve a resultset using
XQuery methods and then generate an XML with a different structure using FOR
XML.

--
Jacob Sebastian
SQL Server MVP
http://www.sqlserverandxml.com

"raj" <2rajesh.b@gmail.com> wrote in message
news:d7f90d48-f9c0-4294-a4a2-f83f4ca0151c@b2g2000prf.googlegroups.com...
> Hi,
> can anyone suggest me in doing the transformation from xml to xsl
>
> i have a column in my DB which is of xml datatype.
> for eg this is my xml content in the column.
>
> <Team name="Braves">
> <Players>
> <Pitcher name="John Smoltz" role="Closer" />
> </Players>
> </Team>
>
>
> i need to select this xml column and do the transformation .
> direct tranformation from xml to xslt is fine,i require how to select
> from the sql and pass it
>
> thanks in advance
> Rajesh