1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| CREATE PROCEDURE spInsertDataDay (@stNomTable varchar(14),
@dtDateMin datetime,
@dtDateMax datetime) AS
DECLARE @stSQLStatement varchar(8000)
DECLARE @stDateMin varchar(10)
DECLARE @stDateMax varchar(10)
SET NOCOUNT ON
SET DATEFORMAT DMY
SET @stDateMin = CONVERT(varchar(10), @dtDateMin, 103)
SET @stDateMax = CONVERT(varchar(10), @dtDateMax, 103)
SET @stSQLStatement = 'INSERT INTO ' + @stNomTable +
' (' +
'Date_Time, ..........' +
') ' +
'SELECT ' +
'Date_Time, ............. ' +
'FROM ARCHIVE_MYHISTO1 ' +
'WHERE (CAST(Date_Time AS datetime) > CAST(''' + @stDateMin + ''' AS datetime)) AND ' +
'CAST(Date_Time AS datetime) < CAST(''' + @stDateMax + ''' AS datetime))' |