XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
cheryl culwellSubject: convert sql statement into xml statement
Author: cheryl culwell
Date: 21 Oct 2010 05:00 PM
I have the following SQL query which returns the data I need to map to an xsd document..I have reviewed the Xquery tutorial and am having trouble starting the conversion to an xml query. Here is the sql query:
SELECT Company_Info.Name, Company_Info.Address, Company_Info.City, Company_Info.State, Company_Info.Zip, Company_Info.Phone,
Company_Info.Contact, Well_Summary.WellID, Well_Summary.YearMonth, Wells.WellID AS wellid, Wells.APICode as apicode, round(Well_Summary.AllocBegInventory,0) as prodbeginv,
round(Well_Summary.AllocEndInventory,0) as prodendinv, round(Well_Summary.AllocOil,0) as allocoil, Well_Summary.DaysOn as proddaysproducing, round(Well_Summary.AllocOilSold,0) as oilsolddispqty, Wells.UserField9 as facformation,
round(Well_Summary.AllocWater,0) as waterprodqty, Wells.Status as facgroup, Wells.WellName, Well_Summary.AllocOilUsed, Wells.State AS wstate, '0' as facamend, 'well' as factype, 'none' as faccomment, 'oil' as prodtype, 'bbls' as produnits,
' ' as disposition, 'sold' as disptype, 'bsw' as disptype2, 'used' as disptype3, 'water' as prodtype1, 'bbls' as produnits1, 'bbls' as produnits,
Leases.ClientID as wclient
Leases ON Wells.LeaseID = Leases.LeaseID CROSS JOIN
Well_Summary CROSS JOIN
WHERE (Leases.ClientID = 15) AND (Wells.WellOperator='PETRO-HUNT, LLC') AND (Wells.State = 'ND')AND (Well_Summary.YearMonth = '2010/05') AND (Wells.APICode IS NOT NULL)

My question is :
is there a tool that will convert this to an xml query? Or, can you give me pointers on how to get started?
thanks in advance for whatever help you can give me.

Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.