Get No of Sundays in a month SQL Server

The following stored procedure returns number of sundays in given month. It takes date as parameter. Month and year is extract from the date.

Test Run

return
4

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*