- 4 Write A Stored Procedure Sales By Store That Takes Int As Input And Performs The Following Procedure To Create A Ne 1 (60.96 KiB) Viewed 34 times
4. Write a Stored Procedure Sales_By_Store that takes (Int) as input and performs the following procedure to create a ne
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
4. Write a Stored Procedure Sales_By_Store that takes (Int) as input and performs the following procedure to create a ne
4. Write a Stored Procedure Sales_By_Store that takes (Int) as input and performs the following procedure to create a new table named Sales_By_Store_Table for the given Store_ID and populate the table with three column info as follow from the three Base tables in the database below. We assume that the new table does not exist in the database. Sales_By_Store_Table : Product_ID (Int) PName (Varchar(30)) SUM(PLineSales) as Sum_PLine_Sales (Int) //for each Product For a given Store_ID from CUSTOMER base table below, the Stored Procedure: Sales_by_Store creates and populates Sales_By_Store_Table that has three columns Product_ID, PName, Sum_PLine_Sales, Where a database has the following three Base tables: PRODUCT PName) PK SALES PLineSales) FK1:Cust ID, FK2: Product ID CUSTOMER (Cust_ID, CustName, Address, PK:
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!