Different "SELECT" statements base on value SQL Server

Question

I have a variable @variable 1 [bit] which tells me either to exclude or not certain data (based on a different value) from a select statement.

Simple example I have a table (plants) with 2 columns :

Name_of_the_plant, numbers

I have a report in which the user should be able to declare a value @WithoutTrees and I should be able to present the result without the trees, based on their names(for which I have a nomenclature).

I want to be able to run the select query based in two ways based on the variable WithoutTrees.

1. When the bit value is 0: SELECT * FROM Plants
2. When the bit value is 1: SELECT * FROM Plants where Name_of_the_plant not in ('Oak', 'Pine')

Answer 1

SQL Fiddle

MS SQL Server 2017 Schema Setup:

CREATE TABLE Plants(
    Name_of_the_plant VARCHAR(255),
    numbers INT
);

INSERT INTO Plants(Name_of_the_plant,numbers)VALUES('Oak', 100),
                                                  ('Pine', 56),
                                                  ('XXX', 90)

Query 1:

BEGIN
DECLARE @variable1 bit 
SET @variable1=1

IF (@variable1 = 0)
BEGIN 
SELECT * FROM Plants
END
ELSE
BEGIN
SELECT * FROM Plants where Name_of_the_plant NOT IN ('Pine','Oak')
END
END

Results:

| Name_of_the_plant | numbers |
|-------------------|---------|
|               XXX |      90 |