Answer:
See the program code at explaination
Explanation:
CREATE PROCEDURE sp_Q1
atcountry1 NVARCHAR(15),
atcountry2 NVARCHAR(15)
AS
BEGIN
BEGIN
SELECT SupplierID, CompanyName, Phone, Country FROM suppliers
where Country in (atcountry1,atcountry2)
SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Products
where SupplierID in(
SELECT SupplierID FROM suppliers
where Country in (atcountry1,atcountry2)) ORDER BY SupplierID
END
END
GO
-- Testing script.
DECLARE atRC int
DECLARE atcountry1 nvarchar(15)
DECLARE atcountry2 nvarchar(15)
-- Set parameter values here.
set atcountry1='UK'
set atcountry2='Canada'
EXECUTE atRC = [dbo].[sp_Q1]
atcountry1
,atcountry2
GO
Note: please kindly replace all the "at" with the correct at symbol.
The editor doesn't support it on Brainly.
