Hum..

now let's say that....He he.

That is what I need.

Guys thank you so much.

This one worked.

I have included some new rows on it with day 21:

What I need is that when the day end the counter reset, the date 2014-01-20 23:00:00 should only...

He he.

It works.

Thanks.:-D:-P;-)

Now...

If I want to reset the counter for all days?

When it change the day, reset the counter.

He he

I agree with you, that's why I say that I was not at home. I post it from my phone. But in an hour or 2 I will post the...

I can do it, I am not at home now. I have a table with only 2 columns. Let's say "eventdate" and "status".

Eventdate is datetime

Status is int.

I have records with...

I realy need some performance on it. So, how can I do it.

The idea is to use blocks of date with hours. I need to make an appointment, and if...

Humm, wrong. Shame on me. It is SQL 2008 or 2012

Sorry about this.