Sql Qlikview

fkeuroglian — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Sql Qlikview

marcus_sommer — Thu, 08 Dec 2016 12:47:42 GMT

AFAIK each kind of valid sql-syntax will work. Limitations could be the database-driver and/or acess rights.

- Marcus