Oh, right! That's what I was missing. The times before 8:30 and after 16:00 don't count. That's where the half hour came from. I didn't chop those off. Explains...

Hi all,

Two things to bear in mind are:

<li style="list-style-type: none">

1. A room can be booked my two different people at the same time but only counts the same...

pietlinden probably has a better solution than me. I'm also testing a solution but I can't work out why the value for Room A on the 22nd is 5.5? I've...

Sorry I wasn't intending to suggest that one method is better than the other.

I could only comment on the second method as that is the only one I've used.

Apologises for...

The other option is to add a new job step - setting the job step to quit with success on failure.  On success - the job step will be...

I am guessing a little bit, and haven't used DTS for a few years, but I think you have two issues:

Line 13 of the script can't find a file

Possibly an...

The inactive copy of the database is read-only but you can switch which copy is active.

You can set failover to manual so it only occurs if you action it.

Thanks for your help. Sorry I was thinking that the problem was with the original data so the conversion task should identify it before it reached the flat file.

I've just...

This information might also help you https://www.microsoft.com/en-in/sql-server/sql-server-downloads

I only have limited SSRS knowledge but it might help me or someone else help you if you could show your SQL code?

From your comment "Within my SQL code..." it...

Thank you for your help. It case it helps anyone else the following works:

CreationDate >= (DT_DBDATE)((DT_WSTR,4)@[$Package::Year] + (DT_WSTR,6)"-01-01") && CreationDate < (DT_DBDATE)((DT_WSTR,4)@[$Package::Year] + (DT_WSTR,6)"-02-01")

Unfortunately I'm not making much progress solving this.

The following works fine:

CreationDate >= (DT_DBDATE)("01/02/2019") && CreationDate < (DT_DBDATE)("01/03/2019")

The following is accepted but doesn't match any records:

            
February 14, 2020 at 6:16 pm
            
#3726002

            
            
                                                
        

There is this information - https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server?view=sql-server-ver15 if it helps?

Some of the text refers to the 2019 version but I set the version on the linked page to 2016 so, in...

Thank you for your help. The editor accepts that value but the filter doesn't work. I think it is something to do with date format. I'll will post more details,...

Thank you for the suggestion. I tried both of those and they didn't work.