sakthi_madan,

Run in query analyser:

SELECT @@ROWCOUNT

SELECT @@ROWCOUNT

The first statement returns a row with 0

The second statement is the count of rows returned from the first, i.e 1 row of 0.

Hope that makes sense.

I got the answer wrong as well... so close yet so far. Good question.

Kev