topic Re: 'Set NoCount ON' in Stored Procedure in QlikView https://community.qlik.com/t5/QlikView/Set-NoCount-ON-in-Stored-Procedure/m-p/642606#M1085630 <HTML><HEAD></HEAD><BODY><P>Can u please send a query you have written?</P><P></P><P>I have been struggling since last week. </P></BODY></HTML> Mon, 08 Oct 2018 09:45:01 GMT pragna666 2018-10-08T09:45:01Z 'Set NoCount ON' in Stored Procedure https://community.qlik.com/t5/QlikView/Set-NoCount-ON-in-Stored-Procedure/m-p/642605#M1085629 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I was struggling to get data from SQL Stored Procedure and tried many ways. SP was executing successfully but was not returning any data.</P><P></P><P>Then we added 'SET NoCount ON' in our SQL SP and it worked successfully.</P><P></P><P>Just sharing one work around if someone is facing similar issue.</P></BODY></HTML> Fri, 06 Jun 2014 11:18:02 GMT https://community.qlik.com/t5/QlikView/Set-NoCount-ON-in-Stored-Procedure/m-p/642605#M1085629 rsdhavle 2014-06-06T11:18:02Z Re: 'Set NoCount ON' in Stored Procedure https://community.qlik.com/t5/QlikView/Set-NoCount-ON-in-Stored-Procedure/m-p/642606#M1085630 <HTML><HEAD></HEAD><BODY><P>Can u please send a query you have written?</P><P></P><P>I have been struggling since last week. </P></BODY></HTML> Mon, 08 Oct 2018 09:45:01 GMT https://community.qlik.com/t5/QlikView/Set-NoCount-ON-in-Stored-Procedure/m-p/642606#M1085630 pragna666 2018-10-08T09:45:01Z