Added that ORDER by at the end of the query, still getting this in Query designer:

12 am

1 am

2 am

3 am

4 am

5 am

6 am

7 am

6 pm

7 pm

8 pm

9 pm

10 pm

11 pm

8...

The guy was only helping with SQL, he barked at me when I mentioned reporting services in one my replies.

Thanks for your replies L.

Where do I add the ...

This the SQL (that J Livingston helped me with over on the SQL forum)

with roomhours (hour_number ,hour_description) as

(

SELECT 0, '12 am' UNION ALL

SELECT 1, '1 am' UNION ALL

SELECT 2, '2...

Hi J,

It's Monday and i'm back on the case.

I cannot create the roomhours table, as the user i have access to does not have write permissions to the datasource,...

This works for my query and allows me to add the parameters:

SELECT Description, StartDateTime, EndDateTime, Name

FROM ...

No worries about the Reporting Services part.

Could you still help with combining your query into mine?

Hi,

Yes that's the code.

It pulls out 140,000 rows. -This is data with bookings for "all" rooms

On the Reporting Services, I have parameters called StartDate (this is the date the user...

Hi J,

I tried your code and the results are exactly like I want. -You make that look so easy!!!!

How do I add your query to my existing query to use...

P.S. i;ve added a bit more info to my above post

Hi,

Firstly my sincere apologies for not posting according to the guide, I hadn't realized when joining that you guys would response, let alone help me with this, so i'm truly...

You are totally right, my mistake, if the exam finishes at 5, then I obviously don't want to include that in the next hour, doh

If the booking begins/finishes at 10:30...

I already have done a query to link 4 tables to produce the four fields I need:

Description

StartDateTime

EndDateTime

Room Name

Being new to sql, how do I add the hour tally and then...

Hi,

Thank you for your help, really appreciated.

I copied the top part into a Query and that worked fine to show the Loginhour in a separate column and changed the...