RE: SQL SELECT statement in XSLT!!!!!!!!!!!!

I've been working with MS SQL Server, and have been doing joins in my SQL
queries, and have been stuck with some unintuitive element nesting, from
MS's "For XML Auto, Elements" switch.

Would dumping each table individually, and linking them with XLST as Michel
has done be a better idea, given that the file sizes aren't too
astronomical?  The benefit being not being stuck with weird nesting.  Is the
performance cost high for that?

I'm just wondering what the best practices are for working with XML from
SQL.

Greg

-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Jeff Beadle
Sent: Wednesday, August 06, 2003 8:22 AM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE:  SQL SELECT statement in XSLT!!!!!!!!!!!!


<WACCTS>
   <curr_iso><xsl:value-of
select="//CURRENCIES[mappings/curr_code=current()//ACCOUNTS/mappings/curr_co
de]/mappings/curr_iso"/></curr_iso>
</WACCTS>


-----Original Message-----
From: michel geadah [mailto:m_ace_g@xxxxxxxxxxx]
Sent: Wednesday, August 06, 2003 4:40 AM
To: XSL-List@xxxxxxxxxxxxxxxxxxxxxx
Subject:  SQL SELECT statement in XSLT!!!!!!!!!!!!


I have three tables:ACCOUNTS, WACCTS and CURRENCIES...
In ACCOUNTS i have a field CURR_CODE but i do not have CURR_ISO field
and
In WACCTS i have a field CURR_ISO
and
In CURRENCIES i have both CURR_CODE and CURR_ISO

The tables are represented in XML like this:

<ACCOUNTS>
  <mappings>
    <curr_code>1234</curr_code>
    etc
  </mappings>
  <mappings>
    etc
  </mappings>
</ACCOUNTS>


<CURRENCIES>
  <mappings>
    <curr_code>1234</curr_code>
    <curr_iso>12</curr_iso>
    etc
  </mappings>
  <mappings>
    etc
  </mappings>
</CURRENCIES>

i want to write this select statement in XSLT:

"Select CURR_ISO from CURRENCIES where CURR_CODE(in
ACCOUNTS)=CURR_CODE(in
CURRENCIES)"
AND THE OUTPUT OF THIS SELECT STATEMET I NEED TO PUT IT IN THE CURR_ISO OF
WACCTS

i am using the ACCOUNTS table as the xml input to the saxon...
The WACCTS xml document is my output.(i.e i get the WACCTS xml document from

the saxon and fill in the WACCTS table).

THX...

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list