Stored Proc issue

[Anonymous]

Hi All

A bit stuck on stored proc

Trying to input parameters

SQL Execute DB.usp_rp_analysis '1222','20151201','20151231';

but getting no results

1222 is required id

20151201 is from date

20151231 is to date

Getting connection but no results, Any ideas why?

Thanks

[jonathandienst]

This problem is in your SQL procedure, rather than in QV. Are the parameters in the correct order, and are they of the correct type and format, especially the dates? What error messages do you get? Does this exact query work in another tool (SQLMS, Toad etc)?

[Anonymous]

Hi Jonathan

Yes it works in SQLManagementstudio when run

i don't get any error messages it just runs and looks like it worked apart from returning no results

all parameters are in correct order

[jonathandienst]

Are you running the proc in SQLMS and QV using the same username?

[Anonymous]

yes

[asgardd2]

How do you call a procedure in QliKView?

I do it like this:

tmpdata:

SQL SELECT OID,NAME FROM GET_OID_NAME(1,1);

[Anonymous · Accepted solution]

Managed to resolve the issue after visiting the following

https://community.qlik.com/thread/3223

I did an ODBC connection using Username and password...Jonathan helped in terms of thinking am i doing this wrong!

But it is now working did the folowing

SQL Execute DB.usp_rp_analysis batchid='1222',@startdate='20151201',@enddate='20151231';