View and Temp table

[DKL01]

Hi,

Can we use temp tables in creating views ? Something like this :

Create view View1

as

create table #Table1
(
col1 int,
col2 int,
col3 int
)


/* code to insert values into #Table1 */
:
:

select * from #Table1
drop table #Table1

go

 

[foxdev]

The only valid statement in a CREATE VIEW command is a SELECT statement. What you'll need for what you are trying to do is a stored procedure.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org