Nader

You need to use recursion to do this.  Have a look through that link (or search for others) and post back if anything isn't clear.  There should...

"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...