The OP said:

you want to search for all users who have an email...

Also, consider the fact that you're grouping by a table that is the "Right" table of a Left Join.  Perhaps it would be better to get the data for the...

For example... all the other tables are left joined vw_UsageReportCached  view.  So, remove everything else form the code not having to do with that view and see what you come...

Start tearing apart the query(ies) in the function.  You know the data is available.  Find out which part of the code in the function is preventing it.

That's reading from a function, not the view.  You don't know if the function is the issue or the view.

It clearly states that you do NOT need to grant sys_admin privs...

source connection must have the sysadmin role, OR have the db_owner role and the SELECT permission on...

I am trying to standardize an address field.  I want to extract the first three words of the full address (ex: 123 Main Street) into a new column.  I...

Who says?  It didn't specify anything about the table.  Consider it to be "most convenient". 😀

I wasn't talking about the code for the view.  I was talking about the simple...

You're missing the point, Scott.  I...

Thank you for the kind...

I tested the view and found that the columns in question does not contain any data, no matter what date range i choose. I also found that table 'auditLevyBreakdown'...

"It Depends"on what "most convenient" means.  You've just added an index that's going to do page splits all over the place unless you use a Fill Factor, which most will...

The problem does NOT appear to have anything to do with the creation of the SMP_FLAG or the assignment of the letter 'X' to it or the use of it...

Then use THAT instead of what you have in the code you posted!!! 😉  Here's what you...