Naming a Temp Table with a Dynamic Date

Question

Is there a way to Name a temp table with a variable date?

For Example:

DECLARE @SomeDate datetime = '12/31/2016'

Select * 
into #?? 
from Table

The end result I'm looking for is #201612

Which DBMS are you using? ("SQL" is just a query language, not a database product) — , Mar 12 '17 at 07:51

score 1 · Answer 1 · edited May 23 '17 at 10:29

1

In SQL Server and possibly others, temp tables (but not global temp tables) are only visible to the session. Multiple sessions can create the temp tables with the same name and they don't interfere with each other. So, possibly all you need is a fixed name.

Check this for more info: Scope of temporary tables in SQL Server

edited May 23 '17 at 10:29

Community

1
1

answered Mar 13 '17 at 15:56

Orhan ODABAŞI

184
7

Naming a Temp Table with a Dynamic Date

1 Answers1