MindHours

due to search criteria in Stored Procedure , i m facing Parameter sniffing issue.

In fact I think you can combine splitted string splits together，just like this following：

create stored procdure AAA
(
   @typeName1 type1,
   ………………
   @typeName2 type2,
   ………………
)
As
declare @sql varchar(max)
set @sql = ……………… + convert(varchar(max),@typeName1) + convert(varchar(max),@typeName2)  --Do combination……
exec(@sql)