topic Re: SQL DECLARE with a UserTable type in QlikView

SQL DECLARE with a UserTable type

maxsheva — Thu, 17 Jan 2019 11:40:09 GMT

Hi,

I am trying to use SQL DECLARE with a UserTable type

SQL DECLARE @Variable UserTable;

It works properly in SSMS but error appears in QlikView

ErrorMsg: Parameter or variable '@Variable' has an invalid data type.

Any help would be appreciated.

jonathandienst — Thu, 17 Jan 2019 13:18:55 GMT

You need to define the table in the declare:

DECLARE @ProductTotals TABLE
(
  ProductID int,
  Revenue money
)

maxsheva — Thu, 17 Jan 2019 16:47:47 GMT

Thanks for quick reply.

It works!