CREATE PROCEDURE dbo.uspGetCustomers @Amount money
WHERE SalesAmount > @Amount
Query for a Stored Procedure
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)