Query for a Stored Procedure

SQLIsGood-7036 176 Reputation points

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
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


    Thanks for your help.

    0 comments No comments