The final solution should have the Current Date in the Where clause.

My query works until I try and add the WHERE Clause.

I finally got the real Table from the off...

Lynn,

Do you have an AS400 or a machine that has DB2 installed?

The syntax is identical to Oracle.

Thanks.

Thanks Lynn for all of your help.

Have a good evening. 🙂

I changed the script to specify the actual Schema and Table Name.

It close but not quite there.

declare @cnt int,

@OracleRowCount int,

...

Thanks Lynn, you are awesome.

declare @cnt int,

@OracleRowCount int,

@OracleSchemaName nvarchar(max),

...

The Server is owned by a software Vendor. I'm not sure what it is. I only have read permissions so...

The following is the code and it works.

I need a variation of this query that return the record count.it to just return the record COUNT as in the second query....

Thanks for all of the help.

It works Lynn.

Ed you code worked as well.

Thank you very much.

You guys have better code than I.

I can get it to execute without the WHERE Clause.

What would it take to add the WHERE with a Date variable to my code...

Lynn Pettis (9/2/2014)

---

Welsh Corgi (9/2/2014)

---

Ed Wagner (9/2/2014)

---

Good. Now all you have to do is look at the format mask of your TO_DATE function.

TO_DATE(''2014-09-02'',''YYYY.MM.DD'')

The date string doesn't match the format...

Thanks.

I need TO_DATE(@CurrentDate,''YYYY.MM.DD'') to...

Sorry Lynn.

I had added the @Where Variable and it caused the variable to go to null.

DECLARE @SQLQuery NVARCHAR(255)

DECLARE @OpenQuery...

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...

Thanks the final result that I'm looking for is to return the record count. I did this before:

SET @SQLQuery = ''SELECT @cnt = COUNT(*) FROM ''...

I got the following to work. I tried executing against the table in my original post but it took forever so I cancelled the query.

SELECT CAST(CAE_RDB_ENTRY_DATE as Date), *

FROM...