Sproc to get First Day of the Month,First Weekday ETC

First Day of the Month, First Weekday, Total Days in this Month, Days In First WeeK, Days In Last Week,Total Weekend Days sample output: Given Date:Jul 16 2005 12:00AM First Day of the Month:7/1/2005 First Weekday (sun=1,sat=7):6 Total Days in this Month:31 Days In First Week:2 Days In Last Week:1 Total Weekend Days:10

2005-07-15 (first published: )

203 reads

Blogs

Regression Testing SQL Saturday Naming

By

I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Error creating Azure SQL Database

By

A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.” What...

Read the latest Blogs

Forums

Easing Back to the Office

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Easing Back to the Office

Missing Data

By Joe Celko

Comments posted to this topic are about the item Missing Data

Password Policy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Password Policy

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers