working discretionary stored way parameters
i am operative stored way several discretionary parameters. parameters unparalleled values it's easy adequate where apportionment like: where (@parameter zero buttress = @parameter) however, instances, where condition some-more complicated: where (@newgroupid zero si.siteid (select gs.siteid from [utilityweb].[dbo].[groupsites] gs where gs.groupid = @newgroupid)) when i uncomment difficult where clauses, query execution doubles execution digest becomes remarkably some-more complicated. while execution digest doesn't worry me, doubling execution query clear problem. is there best use settlement others have found operative discretionary parameters stored procedures? is those instances where enterprising sql improved solution?