Project Detail

Database Query DB2XML

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

| More

Status: Cancelled

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 offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (1 reviews)

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

Report Violation

Job Type

See more: contact, database, design, extract, file, make, product, query, submit, xml

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

1 day

07-02-2008 14:25 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

I can do your query right away.

nadesolutions offline

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.

self offline

1 day

07-02-2008 08:50 EDT

(No Feedback Yet)

Check the PM please, thanks

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.