Convert view to stored procedure or temporary table

[darthmoht]

Hello, I'm working with Actuate 5 in a Crystal Report conversion. We use SQL 2000 views to obtain complex data for our Crystal Reports. Actuate cannot handle views, only stored procedures.

We use the views to get a subset of our database, we than use an ASP page to pass SQL queries with parameters against the view to populate our report.

Is there a way to create a temporary table on the database, then use ASP to query the temporary table? This could solve my problem as long as the temporary table is either created each time the report needs to be viewed or persistable.

 

[Niv3k]

Temp tables do not have the persistance for good ASP coding, in my experience.

I think your best bet would be to create a stored proc that said:

CREATE PROCEDURE bob() AS
SELECT * FROM queryname
GO

It's cheesy, but it might work.

Kevin