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:
Current query being used
thank you for your help,
mrotor
mainrotorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I want the WHERE clause to be included whenever the @Team variable is greater than 0, and exclude it if it is 0.
WHERE clauses don't 'do' exclusion, so you have to do an OR clause to compare..
WHERE (k.TeamID = @Team AND @Team > 0) OR (@Team = 0)

Open in new window


Also next time please post your code in a code block so we can copy-paste and work with it if needed..
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nitin SontakkeDeveloperCommented:
Or here is another approach:

where 1 = case when isnull(@Team, 0) = 0 then 1 else case when k.TeamId = @Team then 1 else 0 end end

Open in new window

0
mainrotorAuthor Commented:
Thank you for your suggestions.  I will try them.

Jim, I will post my code next time.


mrotor
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.