Stored Procedure Question

[BeginnerUser]

I created my first stored procedure populating from and to temp tables. They exec properly in sql. But when I select the sp in Crystal, it gave me an error 'crw32.exe has generated errors and will be closed by Windows'.

But when I populate an actual table rather than temp table, it works. I'm not sure why I can't use temp tables? I did set nocount on.

Thanks

 

[synapsevampire]

Check:

http://support.crystaldecisions.com/library/kbase/articles/c2005680.asp

If this doesn't help, kindly include CR version information, database type and form of connectivity.

-k

 

[BeginnerUser]

Thank you, thank you so much
I had been missing the begin and end for the procedure. Thanks a lot.