programming

posted by .

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.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. it

    Explain how you would create the users for the sales organization unit and how to set up work groups in this particular situation. Keep in mind that you may have to name certain applications and allowable tasks for each individual …
  2. Access

    A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named uery1, which combines the data from the tables. If the Products table is deleted, what will happen …
  3. SQL Server

    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 all the data from …
  4. programming

    You have the final sales figures for the four quarters in 2010 for Bennets Used Auto Sales, and you are to design a program that asks for the sales figures, computes the total sales for the year, and calculates and displays the average …
  5. programming

    a sales report. Each record in the file contains a customer's number and name, a sales amount and a tax code. The tax code is to be applied to the sales amount to determine the sales tax due for that sale, as follows: Tax code Sales …
  6. C Programming

    Write a C program that accepts sales made by 5 sales reps for the 4 months that they have been selling the company's products. The program should then find the total sales for 4 months, total sales for each sales rep, and total sales …
  7. C Programming

    how do i write a C program that accepts sales made by 5 sales reps for the 4 months that they have been selling the company's products. The program should then find the total sales for 4 months, total sales for each sales rep, and …
  8. java programming

    Create a Sales application that prompts the user for a series of sales figures and then implements a sorting routine on the sales figures. Output. Enter the number of sales made today: 15 Enter the amount of sales 1:25 Enter the amount …
  9. programming

    Design a program and write program that will read a file of sales records and produce a sales report. Each record in the file contains a customer's number and name, a sales amount and a tax code. The tax code is to be applied to the …
  10. Programming c++

    a sales report. Each record in the file contains a customer's number and name, a sales amount and a tax code. The tax code is to be applied to the sales amount to determine the sales tax due for that sale, as follows: Tax code Sales …

More Similar Questions