Project Detail

Database Query DB2XML   Trial project

Database Query DB2XML is project number 281512
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Cancelled by Service Buyer)

Selected Providers: -

Budget: $30-250

Created: 07/01/2008 at 15:23 EDT

Bid Count: 3

Average Bid: $ 48

07/02/2008 at 15:23 EDT

Project Creator: devimich28 View PM Post PM
Employer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 (1 reviews)

Bid On This Project
 

Description

Design a Query to extract all the invoices and their line items, along with the Ship-to information and contact details for each invoice, as well as the product and associated supplier information for each line-item product, for all the invoices that have a shipToState of ‘NSW’. The information extracted should be the same (though not in the same format) as that which was included in the
sample invoices.xml file.

Generate the XML file for the output, by setting the file output options in DB2XML. Make sure the Query to generate the XML output is included as an attribute of the table element of the XML document, as shown in the above listing. Submit the XML file as the solution to this project.




Additional files submitted:
flamingoV2.mdb
project1.doc
invoices.xml

Messages Posted: 0 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options

  View PM Post PM

45

1 day

07-02-2008 14:25 EDT

I can do your query right away.

help

  View PM Post PM

50

0 days

07-02-2008 10:25 EDT

(No Feedback Yet)

Hi I can do this I have done this before and Please check you PMB for sample Result.

help

  View PM Post PM

50

1 day

07-02-2008 08:50 EDT

(No Feedback Yet)

Check the PM please, thanks

help

    Bid on this Project