<div>
Hi ,<br />
&nbsp; &nbsp; &nbsp;Yes , you can use it.try this.<br />
&nbsp;
<pre><code id="code-8204674">Drop Table #T
GO
Select * into #T from [test]
GO
Drop SYNONYM TT
GO
CREATE SYNONYM TT FOR #T
GO
Drop VIEW TV
GO
CREATE VIEW TV AS SELECT * FROM TT
GO
SELECT * FROM TV</code></pre>
<br />
Technically you can use it like this . <br />
But still i did not get the logic of using temporary table in views.<br />
<br />
Cheers
</div>


Hi ,
     Yes , you can use it.try this.
 

Drop Table #T
GO
Select * into #T from [test]
GO
Drop SYNONYM TT
GO
CREATE SYNONYM TT FOR #T
GO
Drop VIEW TV
GO
CREATE VIEW TV AS SELECT * FROM TT
GO
SELECT * FROM TV


Technically you can use it like this .
But still i did not get the logic of using temporary table in views.

Cheers

<div>
<div class="content wysiwyg-content">
hi all,<br />
<br />
I can used TemporaryTable into a view?<br />
I know it is an advanced question so please just who have a serious answer response as usual.<br />
<br />
Please advise.<br />
<br />
T U a lot
</div>
</div>


hi all,

I can used TemporaryTable into a view?
I know it is an advanced question so please just who have a serious answer response as usual.

Please advise.

T U a lot

using Temporary Table in view+ms sql server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.