deal!

I'll post my solution if I got any.

so far, we've been putting this report on hold. will let you know if anything comes up.

Hi everyone,

thank you for the reply. i was offline yesterday so i cant reply.

@Brigadur: yes, that grouping is what i want.

@mark-3,

thanks Jeff for your script, however, it gives same problem as my first grouping logic.

thank you for the reply guys, however dense_rank does not solve it. i have a better data that shows my problem:

with table1 as

(

select dt, cat

from

(

select '2009-09-09 06:18:16' as dt,'OD' as...

you are the best...

it is exactly how i want it..

thanks so much.

the aggregation is base on the the timecode and the timeline.

so in this example:

timecode datestart ...

hi all, thanks for the replies.

I've managed to get around this problem by adding a new dataset (not really a solution, huh? ) that can easily be translated into...

Hi Mahesh, thanks for the reply.

Unfortunately, I can't use Cristal Report or any other technology. I have to do everything on the backend.

sunil.si (12/11/2008)

---

Friends,

How to get all the rows in the below mentioned table that matching the condition of checkInTime less than 2 hours of currenttime?

TableName -> EducationDepartment

Columns -> empID, checkInTime (datetime).

I...

thank you very much.

it's doing what I want.

thank you