SQLServerCentral / SQL Server 2005 / SQL Server 2005 Integration Services / Rename TableName To Datetime / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:24:18 GMT20RE: Rename TableName To Datetimehttp://www.sqlservercentral.com/Forums/Topic521538-148-1.aspxdeclare @TableName char(50)select @TableName = 'PING_' + left(convert(char(50), getdate(), 120), 4)print @TableNameexecute sp_rename 'PING', @TableNameMon, 23 Jun 2008 02:50:24 GMTSuresh B.Rename TableName To Datetimehttp://www.sqlservercentral.com/Forums/Topic521538-148-1.aspxHi.I'm working on a script that moves data from one table to another (This one is created dynamic).I'm using:USE ping_statisticsGOSELECT * INTO PING_TempFROM HostbackupEXEC sp_rename 'PING_Temp', 'HostInfo_(getdate)'Where I would like the name of the new table to be"PING_2008" Where 2008 is the current year.Can anyone help me here?\Jan.Mon, 23 Jun 2008 00:04:18 GMTJan A