topic How to use a variable instead of a Query/ Proc in QlikView https://community.qlik.com/t5/QlikView/How-to-use-a-variable-instead-of-a-Query-Proc/m-p/1028149#M347312 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to pass a variable with procedure instead of direct execute statement.</P><P></P><P><IMG alt="Qlick Query.png" class="jive-image image-1" src="/legacyfs/online/122833_Qlick Query.png" style="height: auto;" /></P><P>I can see the statement loaded in the variable, but the EXEC statement is not working.</P><P></P><P>ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Could not find stored procedure 'Query'.</P><P>QueryResult:</P><P>SQL EXEC Query</P><P></P><P>Please help!</P></BODY></HTML> Wed, 27 Apr 2016 08:46:54 GMT 2016-04-27T08:46:54Z How to use a variable instead of a Query/ Proc https://community.qlik.com/t5/QlikView/How-to-use-a-variable-instead-of-a-Query-Proc/m-p/1028149#M347312 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to pass a variable with procedure instead of direct execute statement.</P><P></P><P><IMG alt="Qlick Query.png" class="jive-image image-1" src="/legacyfs/online/122833_Qlick Query.png" style="height: auto;" /></P><P>I can see the statement loaded in the variable, but the EXEC statement is not working.</P><P></P><P>ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Could not find stored procedure 'Query'.</P><P>QueryResult:</P><P>SQL EXEC Query</P><P></P><P>Please help!</P></BODY></HTML> Wed, 27 Apr 2016 08:46:54 GMT https://community.qlik.com/t5/QlikView/How-to-use-a-variable-instead-of-a-Query-Proc/m-p/1028149#M347312 2016-04-27T08:46:54Z Re: How to use a variable instead of a Query/ Proc https://community.qlik.com/t5/QlikView/How-to-use-a-variable-instead-of-a-Query-Proc/m-p/1028150#M347313 <HTML><HEAD></HEAD><BODY><P>You need this to set the variable correctly:</P><P></P><P>SET vDynamicQuery = peek('Query',0,'QueryTable');</P></BODY></HTML> Wed, 27 Apr 2016 15:31:34 GMT https://community.qlik.com/t5/QlikView/How-to-use-a-variable-instead-of-a-Query-Proc/m-p/1028150#M347313 Gysbert_Wassenaar 2016-04-27T15:31:34Z Re: How to use a variable instead of a Query/ Proc https://community.qlik.com/t5/QlikView/How-to-use-a-variable-instead-of-a-Query-Proc/m-p/1028151#M347314 <HTML><HEAD></HEAD><BODY><P>Thank you Gysbert! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />‌</P></BODY></HTML> Wed, 27 Apr 2016 16:46:19 GMT https://community.qlik.com/t5/QlikView/How-to-use-a-variable-instead-of-a-Query-Proc/m-p/1028151#M347314 2016-04-27T16:46:19Z