I finally figured it out. It was the lack of a format mask on the date conversion. I changed

to_date(LAST_UPDATED_DATE)

to

to_date(LAST_UPDATED_DATE, 'YYYY/MM/DD HH24:MI:SS)

and now the code works.

Rob

Greg Charles (6/30/2008)

---

When using EXECUTE AS to impersonate a user, the scope of impersonation is restricted to the current database. You can't use it to access objects in another...

Sometimes in an attempt to keep things simple and easy I actually wind up complicating them. And possibly affecting performance. I suppose it is all part of learning.

BTW...

Jack Corbett (3/27/2008)

---

Rob,

I usually explain things in detail because you never know the expertise of the poster so I like to try to make it so anyone can understand it.

I...

Jack Corbett (3/27/2008)

---

Robert,

I have looked at the plans and the executed statements. If you look at the executed statements they are 2 different statements because the one using the...

Jack - no, I am not currently using a stored procedure. And no, I am not creating the SQL dynamically within SSRS. Just using plan SQL with parameters.

I've...

I've thought about converting SSRS so it calls a Stored Procedure and thus I could have more control over the SQL. The downside is the way SSRS passes parameters...

When you say plan cache/data cache, I'm guessing this refers to the system caching the plan...