"Albe V°" <vaccariTOGLI_QUESTO@hotmail.com> wrote in message
news:sgtQa.172975$lK4.4901625@twister1.libero.it...
> We're working on a new release of a software.
> In the existing version, each client connects and executes a long batch of
> analysis on some tables.
>
> In the new release, we need to allow each client to execute analysis on a
> subset of data, according to certain login information.
>
> Our idea is:
> 1) Connection to db
> 2) Creation of one View according to restrictions
> 3) Execution of analysis using just created view and some tables.
>
> The problem is that executing
> create view myvista as
> select * from tb_data where testo='A1'
> from two different clients, creates just one view.
>
> Question: Does it exist a way of creating a VIEW with a connection scope,
> something like 'select into ##temptable'?
>
> We tried Create View #MyVista or ##Myvista, but this name is not accepted.
>
> Alternative way, is creating a ##TempTable, at the beginning of the batch,
> and using it as data source instead of full table, but, due to really huge
> amount of data, this could really disturb server performances.
>
> Thanks for any help
>
> Alberto
>
>

> Our idea is:
> 1) Connection to db
> 2) Creation of one View according to restrictions
> 3) Execution of analysis using just created view and some tables.
>
> The problem is that executing
> create view myvista as
> select * from tb_data where testo='A1'
> from two different clients, creates just one view.
>
> Question: Does it exist a way of creating a VIEW with a connection scope,
> something like 'select into ##temptable'?