I have used the stored procedure that I created in SQL Server in my crystal report.
However, when I am trying to run the report, it gives me the following error message:
General SQL Server Error: Check MEssages From the SQL Server.
Error Detected By Database DLL.
WHY AM I GETTING THIS ERROR???
Also, in the stored procedure I have created a temp table as ##temp_coll. I have a select statement in my stored procedure as
select * from ##temp_coll
Please help.
Thanks.
However, when I am trying to run the report, it gives me the following error message:
General SQL Server Error: Check MEssages From the SQL Server.
Error Detected By Database DLL.
WHY AM I GETTING THIS ERROR???
Also, in the stored procedure I have created a temp table as ##temp_coll. I have a select statement in my stored procedure as
select * from ##temp_coll
Please help.
Thanks.