By using this table below I need to Write a SQL statement that creates a stored procedure with one int input parameter. The stored procedure selects the supplierId field and the total of all Count field values for each group of supplierId's from the Part table. Only rows with their Count total, or sum, greater than the value specified in the input parameter should be returned. Hint: Each returned record has a unique SupplierID value, since we are dealing with groups. I am using MS Server 2008.

Question

By using this table below I need to Write a SQL statement that creates a stored procedure with one int input parameter. The stored procedure selects the supplierId field and the total of all Count field values for each group of supplierId's from the Part table. Only rows with their Count total, or sum, greater than the value specified in the input parameter should be returned. Hint: Each returned record has a unique SupplierID value, since we are dealing with groups. I am using MS Server 2008.

Here is the table:
CREATE TABLE Part (
Partid int IDENTITY PRIMARY KEY,
Supplierid int NOT NULL
REFERENCES Part (PartID),
Description VARCHAR (25) NOT NULL,
Count int NOT NULL,
Class VARCHAR (5) NOT NULL,
Inspection smalldatetime NOT NULL);

Answer 1

You need to indicate what SUBJECT this is -- math, science, computer programming, what?

Answer 2

To create a stored procedure in SQL Server 2008 with one int input parameter and select the supplierId field and the total Count field values for each group of supplierId's from the Part table where the Count total is greater than the input parameter value, you can follow these steps:

Step 1: Open your SQL Server Management Studio.

Step 2: Connect to your SQL Server 2008 instance.

Step 3: Open a new query window.

Step 4: Execute the following SQL statement to create the stored procedure:

```sql
CREATE PROCEDURE GetSupplierPartsWithTotalCountGreaterThan
@inputCount int
AS
BEGIN
SELECT Supplierid, SUM(Count) AS TotalCount
FROM Part
GROUP BY Supplierid
HAVING SUM(Count) > @inputCount
END
```

In the above SQL statement, the stored procedure is named "GetSupplierPartsWithTotalCountGreaterThan". It accepts one input parameter named "@inputCount" of type int.

The SELECT statement inside the stored procedure retrieves the Supplierid and the sum of the Count field values for each group of Supplierid from the Part table. The GROUP BY clause groups the records by Supplierid. The HAVING clause filters the groups where the sum of the Count field values is greater than the input parameter value.

Step 5: Execute the SQL statement.

Now, you have created the stored procedure "GetSupplierPartsWithTotalCountGreaterThan" with one int input parameter. You can call this stored procedure and pass the input parameter value to get the desired results.