• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

using Temporary Table in view+ms sql server 2005

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
0
MKItani
Asked:
MKItani
  • 2
1 Solution
 
mimran18Commented:
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

Open in new window


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

Cheers
0
 
MKItaniAuthor Commented:
not what i am looking for.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now