No. I understand variables. That was not my question. I'll try to break it down deeper. My question is how to load an excel that contains sheet$ that...

OK Thanks! I understand exactly. This should work great! Thx so much!!!

Okay, I understand how your code is working now. But your sample data is not like my sample data. My data doesn't always have 6 characters. It...

Okay, I have created this code to convert the bigint into time.

SELECT *, CONVERT(BIGINT(6), ACT_TIME, 114) AS NEW_ACT_TIME

FROM dbo.tbl_table

I receive this error:

Msg 291, Level 16, State 1,...

I'm not sure what you are representing when you say "stuff"("stuff"

And what does the '00000' represent?

Select *

,stuff(stuff(right('00000' + cast(TimeValue As...

This works great!!! although now it has been requested that I get detailed results. So now I am trying to get a different looking result on my report. ...

I think we are really close, but when I add a date range in my WHERE clause(see below)

WHERE DATEDIFF(mi,L1.Start_Entry,L2.Start_Entry) < 60 AND Start_Entry BETWEEN '07/01/09' AND '07/23/09'

I get this...

I think this is going to actually work! yeah! Although my table contains dates ranging from 1/1/09 to Current 7/23/09. If I want to narrow the range of...

I sent the rules... Here they are again

Detail:::: If the file name is the same as 'any' other file name, AND it's match has the same Emp ID, AND 'any'...

I see exactly what you are saying. You are correct, and it should read '3' entries. I didn't take into consideration of the 3rd entry within 60 minutes...

1 row for the day showing 2 occurances(something like the example below). I do not need to see any results with 1 occurance in 60min range.

Emp_ID ...

The result should be 2.

Which ones?: See below

Emp_ID Start_Entry End_Entry ...

This is what I've created so far to resolve the issue. It's not giving me exactly what I want, but it is what I've created so far.

SELECT Emp_ID, Start_Entry...

This is only working if the HH(hour) starts exactly at the top of the hour and ends at the top of the next hour. (i.e. if it starts...

It will be based on Start_Entry. thx