Thanks for the answer.

Thanks for help. I found that there are another way to do this. This method is to create SQL function. This function is to split the CID into the table...

Thanks all guys~~

exactly yes.

Sorry for misunderstanding you. I have edited my post. See if you understand my question. Because there are so many situations happened in my case. Sometimes, the total number of arrival records...

Well, In fact, The above is just a sample that is similar to my case. Actually my case is:

I have the table like this:

ArrDep

id       pid        adDate         adTime       adPort     adType

1     020004   10/11/2007      11:00          HKG         A

2    ...

Hi David, I think the result of the query you have written is not my expected result.

Suppose there are two tables:

Table A:                          Table B:

id     value                       id      value

1       A                           4        D

2      ...

It works but this is not a result I want. I think the query should use group by function.

My company has a table called AccessLog in SQL Server. It stores all of the staff attendance records. And the struture of this table can't be change because the time...

It works exactly. However, the speed of query execution is not good enough because of my big size table. Is there any faster method?Sorry for bothering you again.

(select distinct EmployeeID, dateadd(d, i, @from) as LogDate from #AccessLog, @Numbers where dateadd(d, i, @from) <= @to)

Why does this query can have a loop function?If doing...

If I query a staff whose employeeid is 0915 and LogDate is between 3/1/2006 to 3/10/2006. the result is shown as following. There is only a record in 3/1/2006.

RCDID       EmployeeID          LogDate      LogTime     TerminalID ...

It works exactly. RyanRandall, Thanks very much. Can you explain your code? I can't understand why left outer join is neccessary.