I've tried the solution of SSCrazy Eights and this solution is perfect.

Is there an explanation why your solution is working and mine not?

You are right. I especially moved to SQL 2008 to use this time field.

I don't think that you have already a forum for SQL 2008?

If I run it without the...

Thanks. This was really helpful.

Also the solution with CTE is very interesting to avoid writing multiple times

RANK() OVER (ORDER BY endTime) AS ranking

I understand. So I have to write the following:

CREATE TABLE #tblResults (participant_id INT, endTime TIME)

INSERT INTO #tblResults VALUES (1,'11:25')

INSERT INTO #tblResults VALUES (3,'11:26')

INSERT INTO #tblResults VALUES (2,'11:27')

INSERT INTO #tblResults VALUES...

How to avoid negative points

I was trying the following:

CREATE TABLE #tblResults (participant_id INT, endTime TIME)

INSERT INTO #tblResults VALUES (1,'11:25')

INSERT INTO #tblResults VALUES (3,'11:26')

INSERT INTO #tblResults VALUES (2,'11:27')

INSERT INTO #tblResults VALUES...

Thanks for the solution.

When the two PC's are connected through network cards it is not a problem. That is working.

But it is when you want to dial-in (or using direct cable connection). It...

Yes I'm running SP1 for SQL2000.

I'm connecting using TCP/IP.

In the second scenario with the direct cable connection it is only possible to use TCP/IP because on Windows98 you can only...