Not much we can go on - would help if you showed the code that is causing the issue.

I am not sure I understand the request - what are you trying to accomplish?  Can you be more specific?

There is the option of filtering the dataset, which you can...

No - but I ask again.  Have...

If the user owns a schema - then they will be able to create objects in that schema unless explicitly denied (and I am not sure if that can be...

One of the reasons you would not want to loop over a list of tables is the fact that you have now serialized the extract and load process.  Using separate...

If you run your alternate function without a where clause or group by - does it return any data?  If it does return data - does it return data where...

It's still a falsehood.  The docs say it is the "false_value", but the result is not "false".  ELSE is accurate, because that simply means the WHEN condition was not...

The rule for SQL expressions and functions is that if a NULL value goes in, a NULL value comes back, unless you explicitly do something to change that.

IIF violates,...

Like a COALESCE with 10 arguments, for...

That is one way - but I probably wouldn't set the function up to return the totals.  Instead I would do this:

USE [a2hr]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE...

CLR functions for performing Regular Expression searches aren't SQL either, but they're useful. Where do you draw the line?

IIF is part of T-SQL and is more succinct than...

Like I said - you could use a function.  But you could also do this:

  WITH prDates
    AS (
SELECT dt.PRStartDate
   ...

Not sure I follow - what CTE are you referring to?  The only CTE in the above statement is prDates - which just returns the date range.  I would create...

Yeah... sorry.  I looked at the original problem the wrong way.  I also didn't realize that 01/04 was in the (I believe) dd/mm format although that should have been...

Here is what I think you are looking for - if I am understanding the code you provided.

  WITH prDates
    AS (
SELECT dt.PRStartDate
...