Lynn,

Sorry I missed your post. I have everything but the date.

This is the exact code that I have.

Thank you.

DECLARE @sqlquery NVARCHAR(255)

DECLARE @OpenQuery NVARCHAR(4000)

DECLARE @OpenQueryPrefix NVARCHAR(4000)

DECLARE @OpenQuerySuffix NVARCHAR(200)

DECLARE @OracleRowCount INT

DECLARE @LinkedServerPre VARCHAR(200)

DECLARE @LinkedServerPost VARCHAR(200)

DECLARE @MyCnt INT;

DECLARE @ParmDefinition NVARCHAR(500);

DECLARE @OracleSchemaName NVARCHAR(60)

DECLARE @OracleTableName NVARCHAR (200)

DECLARE @CurrentDate Date

SET @CurrentDate= CONVERT(DATE, GETDATE());

SET @OracleSchemaName = 'RDB_DWH_POLICY'

SET @OracleTableName = 'COVERAGE_ASSOCIATE_ENTITY'

SET @LinkedServerPre = 'LS_'

SET @OpenQueryPrefix = 'SELECT @cnt = OracleTableCount FROM OPENQUERY(' -- << here

SET @OpenQueryPrefix = @OpenQueryPrefix + @LinkedServerPre

+ @OracleSchemaName --+ @LinkedServerPost

SET @OpenQueryPrefix = 'SELECT @cnt = OracleTableCount FROM OPENQUERY(' -- << here

SET @OpenQueryPrefix = @OpenQueryPrefix + @LinkedServerPre

+ @OracleSchemaName --+ @LinkedServerPost

SET @OpenQueryPrefix = @OpenQueryPrefix +'52'

SET @OpenQueryPrefix = @OpenQueryPrefix

+ ', ''SELECT COUNT(*) OracleTableCount FROM ' -- << and here

DECLARE @Where VARCHAR(200)

-- I need to add the following to the string.

-- WHERE CAE_RDB_ENTRY_DATE > = TO_DATE(''2014-08-08'',''YYYY.MM.DD'') ORDER BY 1')

-- I need to use the @CurrentDate variable as opposed to hard coding it

-- That is all that I need but the quotes are not comming out right.

SET @OpenQueryPrefix = @OpenQueryPrefix

+ @Where

SELECT @OpenQueryPrefix AS OpenQueryPrefix

SET @OpenQuerySuffix = ''')'

SET @OpenQuery = @OpenQueryPrefix + @OracleSchemaName + '.' + @OracleTableName + @OpenQuerySuffix

SET @ParmDefinition = N'@cnt int OUTPUT'

EXEC sp_executesql @OpenQuery, @ParmDefinition, @cnt = @OracleRowCount OUTPUT;

SELECT @OracleRowCount AS OracleRowCount;