I am selecting certain records from a table randomly and saving them in a temp table. I have created a stored procedure to select into this table and need to pull these randomly generated records in different parts of my c# code . Another stored procedure to pull the values from this sp later on. While trying to run the first stored procedure i am getting this error
"The return types for the following stored procedures could not be detected. Set the return type for each stored procedure in the Properties window."
Any ideas how to fix this error or a better approach to handle this situation?
I have also tried creating a table variable as mentioned on this site http://odetocode.com/code/365.aspx
but I can't access this Table variable in second stored procedures in parts of code