Need an example of a static store procedure that use dynamic filters? [filters to search information for the user, that will be used in the query if they have information, if don't, that filters are disabled or at least the workaround they have to avoid the dynamic procedures?]
It may be because there is a client requirement where the client says something like "you can't use variables in the store procedures"
The key is in the where clause, let's say that you want to get a list of employees based on fields:
id_empresa, id_cargo, id_departamento, nro_personal and id_proceso, but you don't know what filter is the user going to choose, could be one or all, the query will look like this: