SELECT convert(varchar(10),calldatetime,8) AS HOURS

FROM Table

WHERE project = 999

AND DATEPART(hh, calldatetime) BETWEEN 3 and 6

--or this depending on the requirements

or DATEPART(hh, calldatetime)  >= 3 and DATEPART(hh, calldatetime)  < 6

AND CALLTIME BETWEEN '2006-12-01...

Maybe it's not.  But it looks like it at this point.  But even with clean data you could have 2 employees with almost identical profiles except for SSN and bank...

Need help??  Just hire a junior DB into the team.

Where do I send my resume?

2 employees could theorically have the same name, even the same adress/phone numbers.  The only unique field should be empID (which even here where I work is not unique but that's...

Anteres you need ot come back more often to this forum... I hadn't learned something new 2 posts in a row for quite a months.

Thanx again.

Can you post some sample data so that I can tune my query.  I think it's the only one so far that can solve this problem.

Lol, or that enough new questions were posted so that this one disappears from the new posts list.

PS You know ai never mean harm don't you, don't you?

Or you can use this sample from my previous aherm  "attemp" .

--BASE TABLE

DECLARE @Jokes TABLE (UserID INT, CatID INT, JokeID INT)

INSERT INTO @Jokes (UserID,...

Yup and it is missing the categoryID part, but I'm sure he can finish up the work now .

Thank GOD (Antares)!. 

I knew there was a better way of doing this. 

Now I'll be able to sleep tonight .

Just use a set based split function (which returns a table).  That way you won't have to use all those "evil" tools .

Lol, what I meant is that there's no need to repost that again... if anyone else feels the need to.

Don't you guys hear my thaughts anymore??

DOH! always the simple stuff.  I never have to on so I seem to forget about it .

No need to double post this message and give him more exposure.  I already e-mail Steve about this.

Let me find his phone number... I'll give him a ring .