Lynn Pettis (9/2/2014)
I did it this way:
declare
@SQLCmd nvarchar(max),
@MyDate DATE;
set @MyDate = '20140808';
select @SQLCmd = N'
SELECT
CAST(CAE_RDB_ENTRY_DATE as Date),
*
FROM OPENQUERY(LS_RDB_DWH, ''
SELECT
*
FROM
RDB_DWH_ASSOCIATE_ENTITY
WHERE
CAE_RDB_ENTRY_DATE > = TO_DATE(''' + REPLACE(CONVERT(nvarchar(10), @MyDate, 111),'/','.') + ''',''YYYY.MM.DD'') ORDER BY 1''
)';
print @SQLCmd;
--exec sp_executesql @SQLCmd;
Sorry, the above is wrong, try this:
declare
@SQLCmd nvarchar(max),
@MyDate DATE;
set @MyDate = '20140808';
select @SQLCmd = N'
SELECT
CAST(CAE_RDB_ENTRY_DATE as Date),
*
FROM OPENQUERY(LS_RDB_DWH, ''
SELECT
*
FROM
RDB_DWH_ASSOCIATE_ENTITY
WHERE
CAE_RDB_ENTRY_DATE > = TO_DATE(''''' + REPLACE(CONVERT(nvarchar(10), @MyDate, 111),'/','.') + ''''',''''YYYY.MM.DD'''') ORDER BY 1''
)';
print @SQLCmd;
--exec sp_executesql @SQLCmd;