What is the most sample and practical way to know the MOM (middle of month) and EOM (end of month) in an store procedure on SQL Server 2005? (without doing a select case / switch)
EOM is the last day of the month, and MOM is the last day of the fortnight. It's seems to be 15 in every month except on february.
Also I need to take care the leap-year, Holidays, businness day option, etc. Like linux.