I am not able to load from sp. its running but no result,its also not showing any error
SQL EXEC test.[test].[GetMyInstance] @Period = '7/01/2016', @User = NULL , @Role = 'Newuseradmin'
Can someone help me on this?
Make sure the SP returns only one result set.
how to check?
Look at the code of the SP
Check out the below link and see if it helps...
Retrieving data ...