subject

MSSQL

Create sp_Q2 as a stored procedure, which takes no input but it performs the tasks
in the order listed below:
(1) sp_Q2 first finds the country of suppliers who supply products with the top 2
highest unit price. It does not matter if these two products belong to the same
supplier or not. Also, it does not matter if the supplier of these two products
are in the same country or not.
(2) sp_Q2 does not return the countries, instead, it calls sp_Q1 (completed
in Q1) using the countries it finds.

Like in Q1, you should include 'go' to indicate the end of script that creates the
procedure and include a testing script to test sp_Q2.

The hint below is just a hint. You don't have to use it if you have a better approach.

Hint: save the countries in a table of any type (e. g., table variable, temporary table,
or using 'select...into') and retrieve one country a time into a variable.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 08:00
What is the algorithm for building a binary tree program
Answers: 2
question
Computers and Technology, 22.06.2019 11:00
Eva has many contacts on the professional networking site she uses which contacts are considered second degree
Answers: 3
question
Computers and Technology, 22.06.2019 20:00
The blank button automatically displays next to the data when you select a range of numeric data which is an available option for creating a chart
Answers: 3
question
Computers and Technology, 22.06.2019 23:30
What are some ways to use a range name in a formula? check all that apply. in the defined names group, click use in formula, and then select the desired name. begin typing the name in the formula, select a name from the autocomplete list, and use the arrow keys and tab key to enter the name in the formula. begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. right-click one of the cells in the range. click formula options, and use the dialog box to add the name.
Answers: 1
You know the right answer?
MSSQL

Create sp_Q2 as a stored procedure, which takes no input but it performs the tasks...
Questions
question
Mathematics, 26.05.2021 03:00
Questions on the website: 13722367