Query for a Stored Procedure

Question

SSMS: 18.6

SQL Server: 2014

I am writing a query and I need to have the following in my stored procedure. How do I write it in the query? Any help would be appreciated. Thank you.

=========================================================

Parameter that allows a user to select that the revenue amount is over x amount (x= keyed in amount)

==========================================================

Answer 1

CREATE PROCEDURE dbo.uspGetCustomers @Amount money
AS
SELECT *
FROM dbo.Sales
WHERE SalesAmount > @Amount
GO

Answer 2

Thom,

Thanks for your help.