|
Home > Archive > ASE Database forum > October 2005 > Create View question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Create View question
|
|
|
| Hi guys! I have a recurring sql that I would like to place
in a view so I can use it in joins with other table. My
problem is it has a lot of if statement(the resultset is
based on a lot of calculation based on the data). Anyway,
right now I have it in a stored proc. Current setup is
evrytime I need a new column, where condition I have to
create a new stored proc or modify it. I'm thinking I'll
create a View to hold the base data.
Is it possible to create a view with something like this?
CREATE VIEW
column names
execute stored procedure...
TIA.
| |
| Bret Halford 2005-10-27, 8:21 am |
| Not like that. You can create a proxy table based on an rpc though,
and if you add a "loopback" entry in sysserveres (a different server
name pointing to the same interfaces file name entry as the server's
"real" name) you can call your procedure as an rpc...
-bret
Anna wrote:
> Hi guys! I have a recurring sql that I would like to place
> in a view so I can use it in joins with other table. My
> problem is it has a lot of if statement(the resultset is
> based on a lot of calculation based on the data). Anyway,
> right now I have it in a stored proc. Current setup is
> evrytime I need a new column, where condition I have to
> create a new stored proc or modify it. I'm thinking I'll
> create a View to hold the base data.
>
> Is it possible to create a view with something like this?
> CREATE VIEW
> column names
> execute stored procedure...
>
> TIA.
|
|
|
|
|