views:

451

answers:

1

a friend of me is asking if i know any reasons why he should not included Temporal or variables tables inside a View in SQL-Server 2000. i could only think that a new table will be created everytime the view is accessed but i am wondering is there are any other concerns.

Thanks,

EDIT: This is not Possible

+7  A: 

Huh, can you even do that?

Server: Msg 4508, Level 16, State 1, Procedure Test, Line 2 Views or functions are not allowed on temporary tables. Table names that begin with '#' denote temporary tables.

SQLMenace
Same thought here...
Tomalak