Query performance and execution plan

See more:

SQL-Server

Hi All,

i have a very long query in sql with some nested if else conditions. basic syntax is like below.

if @somevarialbe = 'A'
BEGIN
Select something from table whre condition = 'A'
END
ELSE 
BEGIN 
IF @othervariable = 'B'
BEGIN
Select something from table whre condition = 'B'
END
ELSE 
BEGIN
Select something from table whre condition = 'C'
END
END

basically my query is very long and identical except these conditions, i am not sure how can i optimize this in a better way

What I have tried:

i have try using exec and create a dynamic query to execute my query. but still the query is taking the same time to fetch around 50000 records for different conditions.

DECLARE @strQuery varchar(max)
SET @strQuery = 'SELECT something from table where '

DECLARE @WhereCondition varchar(500)

if @somevariable = 'A'
BEGIN
SET @WhereCondition = 'condition = A'

Exec CONCAT(@strQuery ,@WhereCondition)
END