Ok, end up with peoples advice,

I will try to do it at front end.

before I thought that abit easy to get the result with query 😀

Thanks for the advice 😉

thank you, it works. 🙂

Iam using datatable from .net app connect to database,

once click [ok] the app calls a store procedure(the 1st step),

to insert all the rows to a table in the database

(one...

my 1st procedure will repeat many time, until all rows been insert to a table.

if I put the 2nd procedure into 1st, how to know when the last row is,...

the point is the output variable return the number of row been insert is 500.

my .net app only return the @insertRowCount one time, that is how many rows been added

there...

Thank you for the answer. I get it.

Thank you all answerd the question.

ok, what I understand from the posts, if I want to display the order of the rows as what I enterd, I have to use...

The thing I didnt do at the beginning, was test the query in a very large database, was large enough I thought, then the process timeout in the application. This...

I understand your query now, I know its abit late to say that.

Related question about the code below

select *

from tblCallLog r

Where DateCall =

(

...

DateCall >=@callFrom and DateCall < @callTo <<< does this part of code already set the range of dateCall

without

not exists

(

select 1

FROM tblCallLog

WHERE phNu=r1.phNu

AND DateCall > @callTo

)

also it select all of the...

yes, ur right i only want the phone number within the rang,

so DateCall >=@callFrom and DateCall < @callTo

is alreadly set the rang,

one thing here iam not understand, do we need...

mister.magoo (1/19/2011)

---

Is it safe to say that the latest call for any phone number will also correspond to the highest "id" for that phone number?

quote]

No, the high 'id' doesn't mean...

below is the table and some data

tblCallLog

id (int, not null)PK

DateCall(datetime, null)

logStatus(nchar(10), null)

phNu(int, not null)

pplName(nchar(100), null)

id, DataCall, logStatus, phNu, pplName

400123, 2011-01-10 15:15:00.000, n, 31695555, b johnson

400124, 2011-01-10 15:16:00.000, b, 46555501, c...

thank you for the reply

but something are not understand

like the union part, and why inner join with the logStatus.

WITH S As (select max(DateCall) MaxDateCall from tblCallLog where phNu=r.phNu group by...

yes, you answered the question completely. thank you.

the reason i asked this, buz the table will go large, "IF" i set the size large, and waste it, then slow down...