John. Thank you so much!

Sorry abt that.

* Need to Pull list of associates who worked less than 6 or 8 hrs for given period of time (Could be a month)

* There may two or...

John,

The requirement is to pull associates who worked less than 6 hrs and 8 hrs if they were PT or FT respectively on a given day.

So the sample data has...

John,

Correct the SQL insert.

Thanks

Mark... This worked like a charm.

Thanks a bunch:-)

Hi Mark,

I'm not getting fruitful results with the query.

Query Used:

WITH CTE1 AS (

SELECT [ASSOCIATEID],[LASTNM],[FIRSTNM],[DateWorked],[HoursWorked],

CONVERT(VARCHAR(8),DATEADD(Day,-ROW_NUMBER() OVER(PARTITION BY [ASSOCIATEID] ORDER BY [DateWorked]),

[DateWorked]),112)...

Thanks Craig,

Here is the script to create the source table

----------------------------------------------

USE [TESTDB]

GO

/****** Object: Table [dbo].[CVTEST] Script Date: 06/28/2011 03:29:01 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE...