Stored procedure temp table returns no columns / data 1

[manuela]

I'm new to stored procedures. Am trying to create a procedure to
1) use a cursor to dump data into a temp table and
2) to then use IF statements with 2 different SELECT statements, based on the temp table, dependent upon user parameters.
Have only got to stage (1). Can see the stored procedure when trying to use it as a data source in Crystal Reports but no columns are showing???
Many thanks

 

[rajeevnandanmishra]

Hi there,
If you can send a few lines of your stored procedure with If statement, we can see what would be the problem.