I have a pretty good understanding of how joins work on 2 tables. I'm asking about 3 or more tables.

Does the 3rd tables JOIN use results of the first...

Thanks rmkmurali...

This is exactly what i was confused about. I was thinking that a LEFT JOIN on table C only joined table A or table B...not both. That that makes...

Let me try to explain the situation a little better.

If a user #1 is connected from 1:00 PM - 6:00 PM

and user #2 is connected from 1:01 PM - 7:59...

OK... I tried out Eugenes code on a much bigger data set. It appears to be aggregating hourly.

08993

18971

28954

38943

48932

58916

68879

78786

88372

96975

104606

112251

12860

13447

14289

15214

16159

17131

18108

1985

2064

2146

2227

2311

What I'm trying to do is get a total hourly count, not a...

Thanks for the replies! You've given me some great ideas. I'll do some testing on larger data sets and see how it goes.

Thanks

Dave

Thanks for the reply!

I'm not sure what you mean...

Ninja's_RGR'us,

Do you have any examples of how to do this? Or can you recommend another way to accomplish this task?

Thanks

Thanks for your replies. I found the definitive answer here...

http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx#passive

Thanks