Subject: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
FROM Wells INNER JOIN
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)
ORDER BY Wells.APICode
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.