Need Urgent Help with Stored Procedures in Qliksense!

[pragna666]

Hi Talented lads and lasses of Qliksense,

I need urgent help while I am trying load SP (Stored Procedure) from within Qliksense. I am encountering the below error :

Below is the query I am trying to execute :

Any help would be extremely useful since I have an important deliverable coming up, thank you so much in advance

[Anonymous]

Have you looked at this?

'Set NoCount ON' in Stored Procedure

[nsetty]

Try

SQL exec [Databasename].dbo.CIMS_SELFREPORT_1_DEPTORDETAIL;

[pragna666]

I did. But I am not sure where to use the SET ON command 😕

[pragna666]

It still gave me the error

[vkish16161]

Try this:

A:

Noconcatenate load * Resident YourTableName;

Drop table YourTableName;

Store A into [lib://ConnectionName/YourTableName.qvd](qvd);

[Anonymous]

This needs to be done in the stored procedure itself.

[nsetty]

Can you make sure stored procedure executes standalone and as well when you invoke through load editor (from Profiler?)

or

using Debugger... Exec should take some time...

I guess you might have already done the above steps?