So, is this the simplest and quickest way to get the last day of any month?
DATEADD(MONTH,x,'2010-Jan-01')
Where x is the month you are looking for the last day.
I've seen a lot of code over the years that performs some sort of find the first day of the month after the month in question, then subtract 1 day. Seems totally unnecessary with this function.