Here's what I ended up with

/****** Object: UserDefinedFunction [dbo].[UTC_LocalTime]  Script Date: 14/06/2018 10:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================

I took your code and tried this:

DECLARE @c3 DATETIME = '2014-03-01 04:00:00.000';
/*
UK DST dates for about 10 years

2015-03-29 01:00:00.000    2015-10-25 02:00:00.000
2016-03-27 01:00:00.000    2016-10-30 02:00:00.000

The power of the function is that it works out the last Sunday of March and October regardless of the year of the date passed in, but you have given...

I Think the key to this is How Excel is treating the string {4,11}

I think the PRODUCT is acting on the 2 values this produces

Head currently blown!

That's a thought!  And I have realised I didn't post where I got to. D'oh!

Here's where I am:

declare @c3 datetime = '2018-03-28 01:00', @c5 VARCHAR(25)

Hi Eirikur
I have modified my query to what you see below, and using your nifty DFZ calculation means I can zero in on the days required to be marked...

This is my take on office automation.  It is a little off-topic from what the OP asked but does create Office files (An Excel spreadsheet) for any given query.

when you upload a DTS package, it gets given a GUID. The jobs refer to this GUID, which will be different on the new server, as it is a...

The way I always remember this is thus: If you refer to the right hand table anywhere is the where clause, you immediately turn that left join into a...

You can find my solution to this here, http://tinyurl.com/3h929cq

I was inspired by Glenn Berry's script and excel spreadsheet downloads, and thought "Surely we can script this?" It...

Kenneth

Very good article. A succinct way to get this to go.

For those that want a bit more depth, Brian Kelly wrote a good article at http://www.sqlservercentral.com/articles/Security/65169/

HTH

Dave J