Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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';
Try this GRANT EXEC ON dbo.xxxxxxx TO <UserName>
sql execute < Sql Proc Name>
sql execute < Sql Proc Name> < parameters>
can you please answer me in details with full syntex.
See this discution.
Ricardo,
I already gone through the link you gave me but unfortunately it is not working for me.
any other solutions ??
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];
TableStorePoc:
SQL Exec [dbo].[GetItemsByCriteriaForUser]
@userId = NULL,
@userIdType = NULL,
@statuses = NULL,
@maxRowCount = 100,
@dateFrom = NULL,
@dateTo = NULL,
@onlyBasketItems = NULL
Not Working need moreSuggestion ??
Is your connection string proper ? are you able to connect to DB ?
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.