Sorry man, I am doing 4 things a once here. Thank you for cleaning that up.

Here is the data.

CREATE TABLE #test
(UID varchar(50),
DateTimeStamp timestamp
);

INSERT INTO #test 'DJeter@yanks.com', '2017-02-06 13:08:49.417'
INSERT INTO #test 'DJeter@yanks.com', '2017-02-06 13:08:49.417'

Ok, so just in case anyone has the same issue, I came up with a query that shows the number of clicks per minute. 

What my associate was asking...

I am not sure how I can replicate data that might not even exist. That is the challenge with this. I am trying to find users that meet this criteria,...

I don't understand Phil. I posted the query that I have been working on. I am not sure what else I can say. I was able to get the query...

Sorry guys, didn't paste the query. The table simply has 2 columns... UID and timestamp (apologies for the crude diagram).

This is the general idea. I am hard...

Thank you very much!!!!!!!!!!!!!!!

I will try this.

Hi Thom,

Thanks for this. Yea, I am struggling with this a bit.

Basically, I need to find Users that are on for 24 hours, with no inactive...

Thanks Lowell.

Is this supposed to be a shared drive? Can it work without? My companies security is locked down, unfortunately.

I will check that out and thank you.

Thank you all for your responses. Being in this industry, I have, of course heard the acronym RTFM. It just makes people feel like they haven't done their research, which...

Wow, I didn't expect hostility. I have been "RTFM", that is why I am asking for help. I love this site (until you responded), and I was hoping someone had...