Concatenate Wheres in a Stored Procedures

Question

Concatenate Wheres in a Stored Procedures

Navigation

#1 by (0 votes)

-2

Could you help me create a query through a Stored Procedure? to select Sales with:

pClient (only when it is not null)
pProduct (only when it is not null)
pSeller (only when it is not null)

List of Sales (p From, PHase, Customer, Product, Salesperson)

ifnull pCliente then cSqlCliente="" else cSqlCliente="and Cliente= pCliente "
fnull pProducto then cSqlProducto="" else cSqlProducto="and Producto= pProducto "
ifnull pVendedor then cSqlVendedor="" else cSqlVendedor="and Vendedor= pVendedor "
cSqlSelect:= "Select * from Ventas where fecha between pDesde and pHasta "+
 cSqlCliente+ 
 cSqlProducto+
 cSqlVendedor
Exec( cSqlSelect)

mysql sql stored-procedure

asked by Luis Torres La Madrid 18.04.2018 в 19:56

source

1 answer

How to change pages without changing the url? [closed] Get the list that is contained between two Data

score 0 · Accepted Answer

It can be in a single query without having to dynamically generate the query.

It would be more or less like that for the client but it would be a similar logic for N variables

Select * from Ventas where fecha between pDesde and pHasta 
AND 
(
     pCliente is null 
    or  Cliente= pCliente
);