Sql Questions

Hello guys,

On that page http://sqlzoo.net/a1d.htm there are 5 questions for SQL.
Can someone to answer them correct?


thanks.

nue of the orders that were backordered YTD. Show the total amount of revenue for items that were backordered. List the items and their associated revenue again in a second list if the order that was backordered was deleted.

p[lease answer the above questions.Attached is the database sturcture. My budget is $ 20

---

Additional files submitted:
Project Information.zip

NET and is easily expanded / adapted later on as more requirements are set.
HOWEVER, if you feel that better development platforms (than .NET) should be used then please make the case for this and be clear on how you would perform this job.

Please state the keywords - READ IT - in your bid so that we can be sure you have read this specification clearly and understand it clearly.

Any questions please PMB me.


Regards

Ron

relatively simple job but I'm afraid we only employ / consider those applicants who can prove that they have the knowledge and experience to do a 1st class job every time.

Any questions please just PMB.

NOTE: This project has been posted again due to the previous winner failing to complete due to personal issues. We have mutually agreed to cancel the previous project and so we are AGAIN looking for a PHP partner.

Thanks

Ron

ght="1"/>

ScreenShots.pdf
Web+Application+Data.xlsx
Quality+QA.zip

and also check how the scoring is done. I need exactly the same but make it like i have told you above in my explanation.
check when you start this trail exam, the menu Main/Option see the options in it, how to select exam, then categories / then number of quesitons//// In Options menu see how we can set Exam Mode / Learning Mode, also see how we can select how the results to be shown, timer to be set etc.. please study it porperly before you start.

s section requires upload of thumbnail images that will need to be randomly rotated in other sections of the website via Javascript or .NET. The Events section is completed with some minor modifications and clean up. The database is SQL and the code for .NET must be VB, no C. Time estimated for the work is 12-16 hours. More "robust" work will be available in the future based on performance. Any questions.. just ask. Will update post as needed.

dada.gif" alt=" " width="834" height="1"/>

I need some one who has experience with asp and sql injection and other bugs and exploits in asp.
Please use the PMB before bidding to ask me any questions about the projec

answered, so that follow up action / email can be generated, iii) various reports to view and export to xls/csv/pdf formats (activity, caseloads, statistical, list of Respondents, list of Supervisors, list of questions, etc.). Bidder agrees that Buyer owns all intellectual property, and agrees that deliverables include all source code, all executables, all scripts, all other files required to run app, and brief description of application architecture.

entries of my customer and the final format should be an xls file. You should be able to extract products (item #, descriptions, price, weight, pcs) And on Customer. You should be able to extract Customer (first name, last name, Email, Street Address , city, State, Zipcode, Phone number, fax number, tax id number, How much he/she has bought till this date) Everything is inside the .sql file.
Please send me message if there are any questions. Thanks.

posts message status updates to our application via means of a Callback URL. Detailed information can be found in the “Callback URL” section under “Message parameters”. Please pass user id and password pamameters and use authentication in a C# callback function. Also require that the database be updated with the message status information received in the callback.

I think this is very clear, but contact me if you have any ideas or questions

esubscribe they can enter their username and
password, make their payment and all the original information
should still be their with their pic, instead of doing it all over
again...

If you have any questions, feel free to contact me directly at
619-405-5282. For consideration, please submit bid along with
your portofolio and at least 3 recent references with their
contact information...

Best Regard,

Nick

Author, Year (with link to view pdf - url based on Filename column)
or a "No articles were found" message

Some notes:

- Simple is the best. Clean code I can rework if necessary. Be willing to answer questions about your code (I'm new to ASP but not to PHP)
- I may need some tweaks after it's complete or may have a question
- Provide generic connection string, table name so I can plug them in. I will not provide you access to the actual database.

Needs:

1. Modify searchbox so that all of the DB fields are being searched.
2. Modify search results display so that the results are sorted based on relevance.

Please only bid if:
1. You have ASP/MS SQL search experience and can do this right away.
2. Have online messenger for communication throughout the process (yahoo, msn, etc) Consistent communication is critical to us.

Thanks! Feel free to ask questions via PMB

pment – xhtml / CSS / javascript?

2/. What is your knowledge of back end web programming – i.e. MS SQL SERVER, .NET C#?

3/. What is your web site address to your portfolio? (We cannot consider applicants that do not have their own web site).

4/. Can you provide at least 3 UK based references or, if not, accept payment on delivery?

Please also attach your CV (company/personal) detailing your experience as a web developer.

Thank you.

uestions  from past exams . They  are about database and sql  query . They are attached and I have circled the required ones.I want someone who  has  a good experience  in this  field to  answer them in a correct simple  way because I will have exam on them next week .  need some explanations if possibe . I would like to have  them done withen 3  days .

For more  details plz pm .

We have a website running on an Access DB. We want to upgrade to SQL DB. We need all the data migrated to SQL and connection changed so website runs on SQL DB. The current Access DB is about 29MB with about 1500 products. The site must be fully tested and functional on SQL DB. Please PM with any questions. Thanks!

te a sql database. Second create forms to post data to the database in asp. Third when the form is submitted it will create a directory on the server in the username. Fourth it will send the company and user a welcome html format email. Fifth data will be retrieved by the details in attachment. Sixth all pages must be center in any browser and should
only display the logo, links and form. Seventh user must be able to upload files in the login. Please review attached directions.