Wondering why you are not using the EOMONTH function for the last day of the relevant months?

@aveek22, totally agree - it depends upon context, we often (hourly) run a query to identify errors being fed from another system (don't ask), if we return 1...

aveek22: That's as I understand it too.

• This reply was modified 5 years, 1 month ago by  graham.wade 69740.

I use, and tell my team to use, the table hint "With (nolock)" to set read uncommitted. Has the advantage of being only applicable to that query and makes you...