Hi Eugine and all, your solution works fine! a lot of thanks for all.

But I Have any trouble more, if I have one type in records like this:

CREATE TABLE #TEMP...

sorry but my results are these...

1015512013-02-20 17:41:45.000

31015512013-02-20 17:41:47.140

5015522013-02-20 17:42:45.000

16015532013-02-20 19:45:45.100

10015512013-02-20 20:41:45.600

4015512013-02-20 20:41:47.000

26015512013-02-20 20:41:49.100

18015532013-02-20 23:45:45.000

for userId = 01552 only has one record when it should have two

and for userid = 01551...

Erin Ramsay (3/12/2013)

---

The requirements shown by your last post are different from the requirements from your first post.

In your first post you state you want only the records that are...

Hi all, thanks for your answers,

if i put this records into temp table these solutions doesn't works.

insert into TEMP select 1, '01551', '20/02/2013 17:41:45.000' --ok

insert into TEMP select 19, '01551',...