I get it now. Thanx for your patience.

The temp table #Data is essentially #Test in my sample data. So, I want to get the number of visits that occur between 3PM and 2AM. It doesn't matter what...

Where would I get the value for @Date?

Here's my where clause, "where convert(time, t.RegistrationDateTime, 121)>='15:00:00.0000000' and convert(time, t.RegistrationDateTime, 121)<'02:00:00.0000000'".

I didn't get any results but, if I run the query with '22:00:00.0000000', I get results.

Thanx.

Thanx.

Thanks for the input. I'll take a peek at your stuff.

Works like a charm. Thanx.

K. Thanx.

This is the function to parse the parameter string. The parameters are doctors' full names that contain commas so, I need to use a pipe or semi colon or something...

Thanx.

Thank you very much.

Thanx. That helps.

I don't get how the cross apply is working. My limited experience is using it like a join. I'm using 2008 Express but, I suppose I could download 12.

This is what I came up with.

;with Data

as

(

selectAccountNumber,

DischargeDateTime,

RegistrationDateTime,

datediff(minute, RegistrationDateTime, DischargeDateTime) as TAT

from #Test

),

TAT

as

(

SELECTWeekEnding,

TAT,

row_number() over(partition by WeekEnding order by TAT) as RowNum,

count(*) over(partition by WeekEnding) as Cnt

FROM Data t

CROSS APPLY...