Query for a Stored Procedure

SQLIsGood-7036 176 Reputation points
2020-10-21T17:43:01.743+00:00

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)

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,302 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,520 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. SQLIsGood-7036 176 Reputation points
    2020-10-21T18:09:39.59+00:00

    Thom,

    Thanks for your help.

    0 comments No comments