New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this topic

pstiglich
Contributor II
Contributor II

Pass a table to a SQL Server stored procedure

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

Labels (1)
Who Me Too'd this topic