Hi everyone:

I have two questions:
1. How is it possible to declare and use variables in views?
2. How to increase the timeout in order to run complex views?

Any help would be appreciated.

Sam

1. You can't. You can use system functions, system variables (e.g. @@rowcount), and user defined functions, but not local variables or parameters.
2. The method for increasing the timeout depends on the mechanism you are using to execute the view. How are you executing the view?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hi Jeff:

Thank you for your post. Views are executed as SELECT * FROM VIEW_NAME. We are running views as ad hoc reports. If I can encrease a time for execution it will solve my problem at this time. Currently it is just times out before finishing calculation.

TIA
Sam

No.

What I meant was what mechanism are you using to "run" the view? Since a view is a virtual table, the only way to query its contents is via a SELECT statement. The question is, how do you "do" the SELECT? For example, Query Analyzer, EM, ISQL.EXE, OSQL.EXE, via an ODBC connection, ADO, ADO .NET, etc etc. Each of these has its own way of setting the command/query timeout.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Jeff,

Thank you for the support. Currently views are running through CR (ODBC connection) and EM for quick look on data. I would like to have an option to quiery timeout either.

RGDS
Sam

By CR do you mean Crystal Reports? If you are using a DSN, then I think you can set the query timeout on the DSN's properties.

I don't think there is a mechanism to set the query timeout running through EM, but there is through Query Analyzer. Click the database, then select Tools/Options Advanced.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com