Could you please be more specific about how you would like to use a stored procedure? Also could you describe your scenario in more detail?
Since from this description I guess you could simply insert more smart search filters on one page (dropdown list, radio buttons, etc.) and bind them to one smart search dialog with results web part. Then you would achieve filter with multiple parameters. Did you try this?