'Set NoCount ON' in Stored Procedure

[rsdhavle]

HI All,

I was struggling to get data from SQL Stored Procedure and tried many ways. SP was executing successfully but was not returning any data.

Then we added 'SET NoCount ON' in our SQL SP and it worked successfully.

Just sharing one work around if someone is facing similar issue.

[pragna666]

Can u please send a query you have written?

I have been struggling since last week.