Sunday
September 21, 2014

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.

Answer this Question

First Name:
School Subject:
Answer:

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 ...
Computer Science-Java - Hi, I have to write a method that returns my first name...
IT - In this assignment, you are going to be gathering information about the ...
Computer Programming (XML) - Using the employees.xml file below, create a DTD ...
Oracle - Im supposed to add the column Status to the Orderlines table. Its data ...
Oracle - I am supposed to do the following problem: Alter the s_ord table to add...
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...

Search
Members