I knew I was missing something. So obvious now :rolleyes:

Many thanks John, much appreciated 😀

I've always used this 🙂

USE master;

GO

ALTER DATABASE MyDatabase

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

ALTER DATABASE MyDatabase

SET MULTI_USER;

GO

Have you tried enabling the UDP ports 1433 (default instance) and 1434 (names instances) in the firewall on the server (incoming & outgoing)? I have found this helps in...

Thanks for all your help guys 🙂

drew.allen (4/12/2016)

LEAD and LAG were introduced with SQL2012. You won't be able to use them if you...

Thanks 🙂 Yes,...

Thanks for that 🙂 Never heard of LEAD before. Very interesting.

Excellent. Thanks for all your help 🙂

Ah yeah, and let SQL handle the year change. Nice one 🙂

I've come across another stumbling block. I think when the end of each tax year is reached, a...

Hi Lweis,

Thats great, many thanks. I'll start trying to digest that. One complication I have realised though is it seems the designer of the source database didn't make...

Hi Ken. That's great, many thanks for that. Much appreciated. The backend is actually Access, but I use these forums for SQL Server queries, so assumed this particular...

Hi all,

I tried looking at these but was unable to get it to work as I wanted. In the end I set a maximum of 10 columns, and aliased...

I agree. I must confess I'd never heard of them before, but I'm pretty new to SQL development and admin.

In this case, the SQL statement needed to run with a...

Thanks all. The CTE and rbednarek's solution both worked.

Guys, this is perfect. Thanks for your help :-):-)