Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Need an SQL query written that will create a row for every…

Customer Question
Need an SQL query written...
Need an SQL query written that will create a row for every possible date. I need it to take all invoices, payments and exchange rates and create a row for each record so that it can be filtered by exact date and provide all information needed as of that date.
Submitted: 8 months ago.Category: Homework
Show More
Show Less
Ask Your Own Homework Question
Answered in 57 minutes by:
11/15/2017
Tutor: the-pc-guy, Engineer replied 8 months ago
the-pc-guy
the-pc-guy, Engineer
Category: Homework
Satisfied Customers: 2,206
Experience: 10 Years as a tutor helping people with their Computer Programming and Networking Assignments
Verified

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.

can you provide a table structure or something to look at, kind of difficult to do anything with info provided

Ask Your Own Homework Question
Customer reply replied 8 months ago
Hello,The solution I am looking for is very complex and requires a very in-depth knowledge of the SQL programing language. I need a little time to get the documentation together so that you can understand completely all the calculations and end result needed.The dataset will be a few million records and include calculations such as document aging and balances.It might be easier to do a remote session so you can determine if you want to even take on such a complex project.
Tutor: the-pc-guy, Engineer replied 8 months ago

i thought what you had was simple if it is really complex, then I best leave to it others, I have several apointments over the next few days and will not be able to give a timely response

Ask Your Own Homework Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Scott Your Own Question
Scott
Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3,040
3,040 Satisfied Customers
Experience: MIT Graduate (Math, Programming, Science, and Music)

Scott is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

LogicPro

LogicPro

Engineer

5,867 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,556 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,698 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

F. Naz

Chartered Accountant

2,190 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
Correct table joins and join fields: Vendors to Invoices (on
Correct table joins and join fields: Vendors to Invoices (on VendorID) Invoices to InvoiceLineItems (on InvoiceID) InvoiceLineItems to GLAccounts (on AccountNo) Correct table joins and join fields: Wr… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
Design and develop the below queries using professional
Design and develop the below queries using professional principles and standards:-A set of SQL Statements that returns all rows and all data for each table in your database. -Two SQL Statements that r… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Are you familiar with this assignment? Resources: The ERD
Are you familiar with this assignment? Resources: The ERD and normalized tables from the Week Two individual assignment, SQL Server® and Reporting Services on the Toolwire® site, and Beginning Microso… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
Please Pass To LogicPro I have previously completed project
Please Pass To LogicPro I have previously completed project 1 attached also for your ref... Would like this completed by Wed of this week. In this project you will perform the physical design and impl… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
The schema of the database is provided below (primary keys
The schema of the database is provided below (primary keys are underlined, data types are omitted):  Student(StudentID, StudentName, Sex, Age, Year, CGPA)  Department(DeptName, NumPhDs)  Professor(… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
Do not report as duplicate: Please read the description of the Pr
Please read the description of the Practice Database Problem. Create a database in MYSQL based on this description and perform the queries. Note: To learn and practice SQL in a better way, please try … read more
Expert
Expert
I have a 2 part project that I need completed. It must be
I have a 2 part project that I need completed. It must be original. It includes a entity relationship diagram and detailed documentation. This is similar to what you did three months ago. I'll tel you… read more
Expert
Expert
can you help me with these sql questions. Using the Northwind
can you help me with these sql questions. Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions: 1. Display the character constant 'Greetin… read more
John
John
Software Engineer
509 satisfied customers
Create the following queries on the ITCO630_A database used
Create the following queries on the ITCO630_A database used in unit 3 and save them all in a file called ITCO630_P5.SQL. Please note that you can execute individual queries in a query file by highligh… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
46 satisfied customers
ABC Markets sell products to customers. The relational schema
ABC Markets sell products to customers. The relational schema shown below represents the main entities for ABC's database. Note the following important characteristics: A customer can make many purcha… read more
John
John
Software Engineer
509 satisfied customers
1 Show the employee ID number and name for only the first three
1 Show the employee ID number and name for only the first three employees (the ones with the three lowest ID numbers). Hint: use TOP while sorting by ID number. Format all columns using CAST, CONVERT,… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
SQL Programming4. Create an INVOICE_2 table from the INVOICE
SQL Programming 4. Create an INVOICE_2 table from the INVOICE table using a select statement. 5. Rename the INVOICE_2 table to INVOICE_3. 6. Add a comment to the INVOICE_3 table definitions describing… read more
John
John
Software Engineer
509 satisfied customers
Project 2 Details: 1. Create Oracle database tables
Project 2 Details: 1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1. Make sure that entity and referential integrity are enforced by declari… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
46 satisfied customers
In this project you will perform the physical design and
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manip… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
Due: Friday, March 01st, 2013IDE: SQL1. Write an INSERT
Due: Friday, March 01st, 2013 IDE: SQL 1. Write an INSERT statement that adds this row to the Invoices table: invoice_id The next id in sequence (find out what this should be) vendor_id: 32 invoice_nu… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
46 satisfied customers
Hi, i need help with homework, this is programming in oracle
Hi, i need help with homework, this is programming in oracle SQL, in order to fully convey the problem i need an address to send the task too as it does involve some diagrams Regards Billy… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
Define database and explain how you could use a simple ...
Define database and explain how you could use a simple database (like Microsoft Access or Microsoft Excel) to track criminal offenses in your local community. Discuss what criteria you would use to ca… read more
Peter
Peter
CEO
Bachelor's Degree
248 satisfied customers
Consider the following three tables as created with
Consider the following three tables as created with SQL: CREATE TABLE HOTEL_INVOICE (InvoiceNumber Integer Not Null, Arrival_Date Date Not Null, CustomerName Char(20) Not Null, Total Numeric (6,2), CO… read more
Brad
Brad
Bachelor's Degree
122 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x