Zzartin sent me to the right direction. I had duplicate values so I had to group it anyway.

i rewrote the query :

select acctno,...

t.tabdate is datetime

ok, I checked with the developer, and while the logic sounded weird to me, it seems is doing what it's intended for.

My problem is that I am having...

Appreciate the input.

I may still suggest noon's DIFFs, to reduce the amount of Tlogs needed during a backup. Tlogs are currently taken every 5 min.

Thanks Gail

So let me see if I understand. On the 1st case, the UPDATE will always run. And if the dates are null for both, it will UPDATE...

Right now, 33, 40 and 45 are hard coded. I already created a simple table with them. So I want to get rid of the IN statement on the WHEN,...

I am using SQL2008, but I will take a look on the actual execution plan. Thank you!