Thank you for your help so far.

I have found a code that brings back a weekly range, but it is not picking up the correct week. Also my week range is Saturday through Friday.

My query:

SELECT ...

Thank you for your information. I will try to put something together that is correct.

I will try this solution. And I think I've found another option to try. Thank you for your help.

This is the dataset query for the hours ranges:

SELECT DISTINCT

CASE WHEN...

I used a case statement in a dataset: CASE WHEN PGM_HRS_ERN BETWEEN '10.00' AND '19.00' THEN '10.00-19.00' ....etc. to give me the ranges:>=45.00, 30.00-44.00, 20.00-29.00 and 10.00-19.00.

When I try...

That worked perfectly. Thank you!

It worked!

Thank you so much!

Since I'm new to posting, do I get to rate your help somehow?

fergusoj (aka jaffie)

The ROW_NUMBER() partially works and it numbers all records, regardless of date. I need to number for each instance of a date for each employee. I need to figure...

End result should look something like this:

Emp 111/17/2010Wed17:57:57 AM1:00:26 PM5:02

Emp 111/17/2010Wed21:30:39 PM5:37:21 PM4:06

Emp 111/17/2010Wed36:03:52 PM8:03:54 PM2:00

The '1' '2' and '3' are the 'shifts' that I need to calculate into the...

No stored procedure. Just simple records with each sign-in transaction counting as one record for either one day or multiple days.

Thank you.