Technical Article

Get Number of Days in month

Have seen existing scripts to work out number of days in month. They tend to work out the month, and then whether it's a leap year.Another approach is to take the date passed in, find the first day of the next month, and then use Datadd to take off one day, ie: last day of […]

4 (1)

2002-10-17

395 reads

Blogs

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs

Forums

Help Parsing String

By Tav29

I can do the Last Name, First Name; my problem is Middle Initial. I...

SSRS REPORT

By RDOT

Hi Guys have project the require to create checkbox in one off my ssrs...

Selecting temp tables & CTEs using PowerBI

By JeremyU

I have a pretty difficult assignment. This is the structure that I need to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers