Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.47 (15)

You rated this post out of 5. Change rating

2011-05-10 (first published: 2011-04-29)

2,414 reads

Blogs

I wanted to figure out how big (or approximately how big) my dump file...

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Forums

I have a table. Structure in script below. I have to compare and see...

I have an application team that is insisting on daily (and for some, weekly)...

i see this in the definition of a linked server on our wh sql...

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';