dynamic query maker design

@shape varchar(50),
@wt decimal(18,2),

begin
 if(@shape = 'abc' and @wt>1)
   begin
       //your calulation   
   end
 if(@shape = 'gef' and @wt>0.5)
   begin
       //your calulation   
   end 

end 

StartRange EndRange ApplicableDisc
1          10       0.1%
10         100      0.2%

with tbl_product as
(
    select 'p1' as product , 1  as wgt, 1000 as price
    union all
    select 'p2' as product , 15 as wgt, 1000 as price
)

select *,
    (price*ApplyDisc)/100 as DiscRs,price-((price*ApplyDisc)/100) as BillPrice
from tbl_product as a
    left join
    (
        --your discount setting table
        select 1  as StartRange, 10  as EndRange , 0.1 as ApplyDisc
            union all
        select 10 as StartRange, 100 as EndRange , 0.2 as ApplyDisc
    )
    as t on a.wgt between t.StartRange and t.EndRange --this is condition e.g. when weight is in range of 1 to 10 discount will 0.1 

Do you need following type dynamic query maker  ?