Reading data from sql server stored procedure is not working

[Anilb1603]

Hi Guys,

I am trying read the data from stored procedure, it has 3 input parameters. I wrote the sql script as below in qlik sense. The qlik sense loading is went successful but I don't see any actual data loaded into qlik sense.

Am I missing anything here? Any help would appreciated.

I used OLEDB connection here.

Data:
Load *;
SQL Exec InfDB_QA.dbo.spReport_Results
@TemplateId = 232
,@StartDate = '8/11/2019'
,@FinishDate = '9/15/2019'
;

Thanks,

Anil

[treysmithdev]

Maybe try this:

Data:
Load *;
SQL Exec InfDB_QA.dbo.spReport_Results '232' '8/11/2019' '9/15/2019';

You might have to adjust your stored proc to have parameters to point to those variables. I don't believe Qlik can pass those variable statements through the driver.

Also, make sure your dates are the default format of the fields so that they are interpreted correctly on the SQL side.

[Anilb1603]

Thanks @treysmithdev

I tried this.

Data:
Load *;
SQL Exec InfDB_QA.dbo.spReport_Results '232', '8/11/2019', '9/15/2019';

Again the load is successful but I don't see any actual data loaded into qlik.

The date format looks fine I executed the same query in SSMS, it is executed successfully and provided output.