Solved

using Temporary Table in view+ms sql server 2005

Posted on 2011-09-05
3
231 Views
Last Modified: 2012-06-27
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
Comment
Question by:MKItani
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Expert Comment

by:mimran18
ID: 36483313
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
 
LVL 9

Accepted Solution

by:
mimran18 earned 500 total points
ID: 36483316
0
 

Author Closing Comment

by:MKItani
ID: 36587116
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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question