I have a stored procedure which contains 3 input parameters with multiple select and Inner joins.
I want to Call the SP in Qlikview. I followed lots of Blogs but I did't got sucess to Execute the SP in Qlikview. Help me.
I am Using OLEDB and my calling method is:
SQL CALL [DBNAME].[dbo].[ABC] @_EndTime ='2012-12-31 00:21:06.550', @_StartTime = '2012-12-31 00:21:06.550',
@_UserName = 'XYZ';
sql execute < Sql Proc Name>
sql execute < Sql Proc Name> < parameters>
Hope this helps
OLEDB CONNECT32 TO [Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=MyDB;Data Source=.;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=WID;Initial File Name="";Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False];
SQL Exec [dbo].[GetItemsByCriteriaForUser]
@userId = NULL,
@userIdType = NULL,
@statuses = NULL,
@maxRowCount = 100,
@dateFrom = NULL,
@dateTo = NULL,
@onlyBasketItems = NULL
Yes connection string is correct I can pull data from any table. but I am looking to call SP in Qlikview.
FYI: in Store Procedure I have multiple select, multiple inner joins and SP is written in two parts union is ussed to join two parts of SP.