mainrotor
asked on
Need help with SQL Query that should determine whether or not to use a WHERE clause
Hi Experts,
I need help rewriting my SQL Server query to determine whether or not to include a WHERE clause.
I have included my query below.
I want the WHERE clause to be included whenever the @Team variable is greater than 0, and exclude it if it is 0.
How can this be done?
Current Query:
thank you for your help,
mrotor
I need help rewriting my SQL Server query to determine whether or not to include a WHERE clause.
I have included my query below.
I want the WHERE clause to be included whenever the @Team variable is greater than 0, and exclude it if it is 0.
How can this be done?
Current Query:
thank you for your help,
mrotor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jim, I will post my code next time.
mrotor