Bill Liu DECLARE @TSQL varchar(8000), @DATE_FROM char(19), @DATE_TO char(19) SELECT @DATE_FROM = REPLACE('2022-04-28T01:07:35Z', 'T', ' ') SELECT @DATE_TO = REPLACE('2022-04-30T01:07:35Z', 'T', ' ') SELECT @TSQL = ' SELECT DateTime AS time, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV FROM OPENQUERY( INSQL, '' SELECT DateTime, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV FROM Runtime.dbo.WideHistory WHERE wwResolution = 120000 AND wwRetrievalMode = "Average" AND DateTime >= ''''' + @DATE_FROM + ''''' AND DateTime <= ''''' + @DATE_TO + ''''' AND wwTimeZone = ''''UTC'''' ORDER BY DateTime ASC '') ' EXEC (@TSQL) error: " db query error: mssql: Incorrect syntax near '.'. " I dont see the '.'. anywhere