Homework Help: programming

Posted by Lisa on Wednesday, May 2, 2012 at 4:20pm.

I have created a Database called Business with the 2 tables as follows:
dbo.Orders
ID
OrderID
ItemName
Quantity
Price
SalesID

dbo.Sales
SalesID
FIrstName
LastName
OrderID

I need to create a stored procedure to show Total Sales of each sales, including SalesID, FirstName, LastName, Total Sales.

No one has answered this question yet.

Answer this Question

Related Questions

SQL Server - I have created a Database called Business with the 2 tables as ...
Access - A database has two tables named Products and Orders. The tables are ...
programming - 3. Write a structured algorithm that prompts the user to input the...
computer science - I need a realational database containing information about ...
college/microeconomics - Just needing to know if I have done the work correctly ...
Microeconomics: - Just needing to know if I have done the work correctly with ...
economics - Suppose the supply and demand for milk is described by the following...
Micro ECONOMICS - The majority of the world’s diamonds comes from Country A...
economics - The majority of the world’s diamonds comes from Country A and ...
adult education - The majority of the world’s diamonds comes from Country A...

For Further Reading

First Name:
School Subject:
Answer: