asked
Need query that will replace only Date part to current date
Need query that will replace only Date part to current date Drop table #table1 select * into # table1 from Main_20170720_table1 Drop table #table2 select * into # table2 from Main_20170720_table2
Build yourself a dynamic SQL string and execute it via sp_executesql Something like DECLARE @sql nvarchar(max) SELECT @sql = 'DROP TABLE....... FROM Main_'+CONVERT(VARCHAR(8),CONVERT(DATE,GETDATE()),112)+_table1' exec sp_executesql @sql
19 People are following this question.
