I had to change my password at work today.  I set it to a 12-character string with a mix of uppercase, lowercase, and numbers.  When I came back from lunch,...

CROSS APPLY isn't the correct approach here.  CROSS APPLY should be used when the subquery is dependent in some way on the main query, and that's not the case here. ...

There are several things wrong with this query.

1)  rCTEs are a HORRIBLE way to do a sequence of numbers.  You're not noticing it, because the size is so...

You haven't given very much detail, and what you have given has a very basic answer, so I feel like you've left out some important details.  Perhaps if you tell...

People often overcomplicate fiscal calculations, because the calendar year is so engrained in our psyches.  I think of fiscal years as a special type of DATETIMEOFFSET where instead of the...