Solved

using Temporary Table in view+ms sql server 2005

Posted on 2011-09-05
3
227 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
  • 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now