Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Expert
I have to run a sql in qlikview, but i do not know if it possible this kind of sql
for example, is possible to run this kind of structure in qlikview? Declare table aux? and do insert
Example:
Load *;
SQL
declare @fecha datetime = getdate()
declare @tablaAux table
(
IdCuenta int,
IdCuentaProducto int,
IdProducto int,
IdSubtipo int,
EsActivacion nvarchar(50)
);
insert @tablaAux;
exec Tablero_AltasPremium $(@Fecha)
AFAIK each kind of valid sql-syntax will work. Limitations could be the database-driver and/or acess rights.
- Marcus