"In a format we can consume" means we can just run the code and don't have to fiddle about copying and pasting your data on to our screen.  It's you...

In your Calendar table, you need to number your weeks, not the day of the week.  So 2017-09-14 (Wednesday) would be week 20 (say), so would 2017-09-15, so would 2017-09-16, and so...

Build your expression from the bottom up.  Does the inner condition ( ISNULL([DC_ManagerCode] )? "FundCode" : "FundCode_ManagerCode_SHC") work?  If so, the error must be in the outer condition.  I suspect...

Create a calendar table with a single day in each row, and a column for the week name or number.  You can then join to that table and use the...

https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql

John

This doesn't make sense.  Where does the lc alias in your WHERE clause come from?

John

Yes.  The database engine doesn't read in units smaller than a page.  So if you want to see something on a data page, the whole page is read into memory....

Why not keep it in a separate table?  If you have it in the same table, you're going to get page splits the first time any row is updated.  You...

char pads with empty space, yes.  That's why you should only use it for short (up to 8 to 10 characters, say) or fixed-length data.  But no, it would be...

Not necessarily, no.  It depends whether your column is variable width (varchar(n), for example), and if so what values are in the column (whether they take up the whole maximum...

The wider your column, the fewer rows you#ll fit on a single data page and hence the more pages are likely to need to be read into memory to satisfy...

It's dead easy if you've got it in Excel.  Add a new column with a sequence number in, then a second new column with a formula something like...

Why is it important to alter the logins in a particular order?  If you really need to, you could try something like this:

SELECT 'ALTER LOGIN '...

I don't know - I've never used that.  But it should be fairly easy for you to test out.

John

Probably the best reason not to grant the permission is that you want to keep your database design confidential.

John