I want to show data in a grid with certain conditions.
I wrote one sp with if else condition
select * from table where status=1
else if(type !=1)
select * from table where status!=1
i pass two command parameter
and in sp i wrote
select * from table where [email protected]
which method is better in performance wise.
please suggest me
new to this field