tsql,sql-server-2008-r2,linked-server,openquery,msdasql
with help from Oleksandr Kucher I managed to do what I want with the below code (I added char(39) to the query string to force the quotes): declare @EarliestDate varchar(8), @SQL NVARCHAR(1000), @sDate varchar(8) SET @EarliestDate= CAST(DATEPART(YEAR,DATEADD(m,-3, getdate())) AS VARCHAR(4)) + RIGHT('00' + CAST(DATEPART(mm, DATEADD(m,-2, getdate())) AS varchar(2)), 2)+ '01'...