Can't u just do it for me?

I won't accuse u of barking again, promise 🙂

Had another go, looked into cte tables. but I haven't clue about constructing the SQL, only new to this:

I would be able to follow it once its working.

Here's by...

Had a go at combing my scripts into the code, but no luck, here is what I tried:

SELECT MachineLocations.CampusID, MachineLocations.Campus, MachineLocations.BuildingID, MachineLocations.Building,...

Hi J,

Just been trying the script out and it looks good. Had a warning about not having permissions to create Table, but it ran ok.

Can you please change the code...

Hi J,

I used the conversion tool mentioned in the FAQs to convert the output into a table for you to use, I didn't test the script post conversion.

For the overlapping...

This took me ages, but here you go.... phew

Dataset 1 Sample Data (Logins)

@StartDate was 21/09/2015

@EndDate was 22/09/2015

Sorted Data and pulled out sample data for Room L1.03

DROP TABLE mytable;

CREATE TABLE mytable(

...

This took me ages, but here you go.... phew

Dataset 1 Sample Data (Logins)

@StartDate was 21/09/2015

@EndDate was 22/09/2015

Sorted Data and pulled out sample data for Room L1.03

DROP TABLE mytable;

CREATE TABLE mytable(

...

This took me ages, but here you go.... phew

Dataset 1 Sample Data (Logins)

@StartDate was 21/09/2015

@EndDate was 22/09/2015

Sorted Data and pulled out sample data for Room L1.03

DROP TABLE mytable;

CREATE TABLE mytable(

...

This took me ages, but here you go.... phew

Dataset 1 Sample Data (Logins)

@StartDate was 21/09/2015

@EndDate was 22/09/2015

Sorted Data and pulled out sample data for Room L1.03

DROP TABLE mytable;

CREATE TABLE mytable(

...

DataSet1 Script (Logins)

SELECT MachineLocations.CampusID, MachineLocations.Campus, MachineLocations.BuildingID, MachineLocations.Building, MachineLocations.RoomID,

...

sorry bout that, I wanted to see if the code was properly formatted before posting the rest of it.

No more edits to it now 🙂

Hi J, I've spent some time gathering the info for you guys, here goes, apologies if I've missed anything.

DataSet1 is to do with PC Logins,

Here is the SQL:

SELECT ...

Hi J,

Me again, this works great. As part of my back story, I mentioned PC logins also need to be included in the hour slots.

Is there a way to combine...

Got the sorting working...... I added J's r.hour_number parameter to the Report fields, and then was able to choose that field in Report Designer and its sorted them correctly.

Thank you,...

Hi J, I was only joking about the bark, you've been more than helpful 🙂

I just tried adding ORDER BY r.hour_number to the end, and it works FINE in SQL...