Question: Lab 5-1 /* Create a function in your own database that takes two parameters: 1) A year parameter 2) A month parameter The function then

Lab 5-1 /* Create a function in your own database that takes two parameters: 1) A year parameter 2) A month parameter The function then calculates and returns the total sale for the requested year and month. If there was no sale for the requested period, returns 9. Hints: a) Use the TotalDue column of the Sales.SalesOrderHeader table in an Adventureworks database for calculating the total sale. b) The year and month parameters should use the INT data type. c) Make sure the function returns a if there was no sale in the database for the requested period. */ Lab 5-2 Create a table in your own database using the following statement. CREATE TABLE DateRange (DateID INT IDENTITY, DateValue DATE, Month INT, DayOfNeek INT); Write a stored procedure that accepts two parameters: 1) A starting date 2) The number of the consecutive dates beginning with the starting date The stored procedure then populates all columns of the DateRange table according to the two provided parameters

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

use py only Complete the remove_0dd_multiples( ) function that takes two parameters: 1. An integer list numbers_list. 2. An integer multiple_of. The function should remove all integer elements in...

WRITE THE FUNCTIONS (DESCRIBED BELOW) FOR A DRINK MACHINE PROGRAM IN C++ USING THE STRUCTURES IN THE GIVEN HEADER FILE: Header File: #ifndef DRINKMACHINE_H_ #define DRINKMACHINE_H_ #include #include...

C++ For this assignment you will be building on the Original Fraction class you began last week. You'll be making four major changes to the class. [15 points] Delete your set() function. Add two...

In this exercise, you will create a single PHP file to display and process a form that is a working Contact Me page. This page will have inputs for the subject, the senders name, the senders e-mail...

This is php class In this exercise, you will create a single PHP file to display and process a form that is a working Contact Me page. This page will have inputs for the subject, the senders name,...

For this homework, use the implementation Graphs.zip. This implementation also provides a simple main function in a file named main.cpp. Graphs.zip have...

For this homework, use the implementation Graphs.zip. This implementation also provides a simple main function in a file named main.cpp. Graphs.zip (includes the following files below in c++):...

In this assignment your task is to design, implement, and test the class hierarchy as described below. 1. Define and implement an abstract class called Structured Matrix. 2. Define and implement a...

The demand for a certain drug in a hospital has been increasing. For the past six months, the following demand has been observed: Month Demand, Units January 15 February 18 March 22 April 23 May 27...

2. Factor the following systems into A = LU or PA = LU, and use the factorization to obtain a solution for (x1, x2, x3). Show all steps to receive full credit. (a) (8 points) x + x3 4 + X2 3 = x2 +...

If a company sells on credit terms of net 3 0 and all of their customers pay exactly be approximately: Accounts receivable turnover = Credit sales ? ? Average accounts receivable 6 times per year 3 0...

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...