Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hello,
I'd like to pass an entire Qlik table to a SQL Server stored procedure using a table parameter, rather than looping through the Qlik table rows and calling the SP once per row. In SQL Server I can define a type (CREATE TYPE dbo.xyz as table ...) and load data into the type, declare a variable as that type, and then pass that variable to a stored procedure.
Can I declare a Qlik variable as that table type and then pass in the Qlik table to that variable and then send it into the stored procedure call?
Thanks,
Pete