Question: Using SQL and Adventure Works Datawarehouse database how do i make a stored procedure named GetAverageProductSalesAmountUSD which will first calculate the USD equivalence of

Using SQL and Adventure Works Datawarehouse database

how do i make a stored procedure named "GetAverageProductSalesAmountUSD" which will first calculate the
USD equivalence of all transactions for the SalesAmount column according to Order Date seen within
the entire FactInternetSales table. Later, in the same stored procedure, filter out for the transactions
that occurred between '01-Jan-2012' and '31-Dec-2013' based on Order Date to calculate average
SalesAmountUSD values for each product. Finally, give the combination output of each Product Key,
English Product Name and calculated average SalesAmountUSD value which contains only 2 decimal
digits for this specified time range. In the stored procedure, include a logging mechanism to keep the
execution datetime of this stored procedure

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 Databases Questions!

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

) Explain the collision detection mechanism applied in standard wired medium access control associated with CSMA and indicate why this might be unsuitable for wireless networks. [2 marks] (ii)...

Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...

In Regards to Question: Janies Pet Minding Janie is a local supplier of pet walking, i have to submit my MS Access file by early next week and can solve it by myself. please help! thank you. Janies...

Janies Pet Minding Janie is a local supplier of pet walking and sitting services for business people. The plan is to eventually grow the business to also provide online accessories to pet owners. A...

Using SQL and Adventure Works Datawarehouse database and the code below DELIMITER $$ CREATE PROCEDURE Create_CustomerGeography() BEGIN DROP TABLE IF EXISTS CustomerGeography; CREATE TABLE...

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

How is the current ratio calculated and what does it measure? How does the quick ratio differ from the current ratio?

Answer the following questions using the data from the Excel file chlorine. xlsx described in Problem 16.32. From Exercise a. Forecast the tons of chlorine shipped each day next week using...

Depository institutions do all of the following EXCEPT A . pool risks. B . lowering the cost of borrowing and monitoring borrow C . determine the interest rate paid on reserves. D . create liquidity.

Case: Luke's Diner has planned sales increase of 7% this year that could be attained due to the introduction and addition of a new dessert snack line. Seasonal reductions are planned to remain the...

John Inc and Victor Inc. formed a joint venture on January 1, 2020. John invested plant and equipment with a book value of $500,000 and a fair value of $800,000 for a 30% interest in the venture...

Coherent light of frequency 6.36 104 Hz passes through two thin slits and falls on a screen 86.0 cm away. You observe that the third bright fringe occurs at 3.12 cm on either side of the central...

Difference between CIBC and credit Agricola ?

Charles and Ellen are unmarried. They run an ice cream shop. The business is not incorporated and they haven t filed any formation paperwork. What type of business do they have

The DBMS does not guarantee that the semantic meaning of the transaction truly represents the real-world event. What are the possible consequences of that limitation? Give an example.

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write none in the space provided. Discuss.

What is a scheduler, what does it do, and why is its activity important to concurrency control?

Suppose we divide Canada into three regions: the West, the Centre, and the East. Each region has an unemployment rate, defined as the number of people unemployed, expressed as a fraction of that...

For each of the functional relations listed below, plot the relations on a scale diagram (with X on the horizontal axis and Y on the vertical axis) and compute the slope of the line. a. Y=10 + 3X b....

Fill in the blanks to make the following statements correct. a. Economists have designed ______ to better explain and predict the behaviour we observe in the world around us. b. A variable, such as...