CODEWITHSUNDEEP
sql-server
Jeremy Morren
Jeremy Morren

Reputation: 764

How to create a "Ghost Table" in SQL Server based off of other tables?

I need to create a "ghost" table in SQL Server, which doesn't actually exist but is a result set of a SQL Query. Pseudo code is below:

SELECT genTbl_col1, genTblcol2 
FROM genTbl;

However, "genTbl" is actually:

SELECT table1.col AS genTbl_col1, 
    table2.col AS genTbl_col2
FROM table1 INNER JOIN table2 ON (...)

In other words, I need that every time a query is run on the server trying to select from "genTbl", it simply creates a result set from the query and treats it like a real table.

The situation is that I have a software that runs queries on a database. I need to modify it, but I cannot change the software itself, so I need to trick it into thinking it can actually query "genTbl", when it actually doesn't exist but is simply a query of other tables.

To clarify, the query would have to be a sort of procedure, available by default in the database (i.e. every time there is a query for "genTbl").

Upvotes: 1

Views: 877

Answers (1)

Arkadiusz
Arkadiusz

Reputation: 489

Use #TMP

SELECT genTbl_col1, genTblcol2 
INTO #TMP FROM genTbl;

It exists only in current session. You can also use ##TMP for all sessions.

Upvotes: 1

Related Questions