Slightly more pedantic approach preventing an implicit conversion

😎

DECLARE @SQL NVARCHAR(400)

DECLARE @WgnWCUser VARCHAR(30)='DBO'

DECLARE @TIMESTAMP VARCHAR(30)='UpdateTimestamp'

DECLARE @datFrom DATETIME='20150916'

DECLARE @datTo DATETIME='20150930'

SET @SQL='SELECT EVENTUID,EVENTTIMESTAMP,EVENTMAJORTYPE,EVENTMINORTYPE INTO #TEMP

FROM ' + @WgnWCUser + '.EMPLOYEE A WITH(NOLOCK)

WHERE A.'+@TIMESTAMP+'>=CONVERT(DATE,'''+CONVERT(VARCHAR(25),@datFrom,112)+''',112)AND A.'+@TIMESTAMP+'< CONVERT(DATE,'''+CONVERT(VARCHAR(25),@datTo,112)+''',112)'

PRINT @SQL;