SQL DECLARE with a UserTable type

[maxsheva]

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 · Accepted solution]

You need to define the table in the declare:

DECLARE @ProductTotals TABLE

(

  ProductID int,

  Revenue money

)

[maxsheva]

Thanks for quick reply.

It works!